Use Parallel Branching and Batching to Accelerate Performance in Power Automate Flow

To optimize the process of transferring a large volume of records from Excel to CRM using Power Automate Flow, the author implemented a solution to divide the Excel data into batches and process them concurrently. The steps involved in creating an optimized Power Automate Flow in CRM are as follows: 1. Create a File Type field on the Opportunity entity to upload the Excel file. 2. Develop a Power Automate flow to trigger modification of the File Type field. 3. Use the "Download a file or an image" step to retrieve the file content. 4. Convert the file content into a string using the compose action. 5. Split each row of Excel by line break using another compose action. 6. Extract the column headings using a compose action. 7. Create an array of objects containing each record of Excel data using the select action. 8. Divide the array into batches using the compose action. 9. Iterate through each batch and perform actions on the data. 10. Create Opportunity Order Product records based on the filtered data. Implementing this batching functionality can significantly reduce the execution time of Power Automate Flow and improve performance.

Article 8m Microsoft Dynamics 365 CRM Tips and Tricks

---

Login now to access my digest by 365.Training

Login