A workflow named SpongeFlow was created to process complex data and perform CRUD operations in Dynamics 365 Business Central. The workflow initially used Power Automate but experienced performance issues. It was then moved to an Azure Logic App Consumption instance, which improved execution time but not significantly. Finally, the workflow was moved to Azure Logic App Standard, resulting in a significant improvement in execution time. The entire process went from taking 14-15 hours to less than 1 hour. The author encourages using the right tool for the job and not relying solely on Power Automate for high-performance and scalable workflows. The full details of the solution will be presented at Directions EMEA 2023.
Login now to access my digest by 365.Training