In this blog, we highlight a lesson learned when we used a Dynamics 365 Customer Engagement online data source connector, called Instance Web API, for Power BI reports.
That's right – no more being limited to mass updating only 250 records at once in Dynamics 365! The Bulk Workflow Execution is a great tool which allows users to run an On-Demand Workflow against a set of records pulled from a System or Personal View, all in bulk! You can find the "Bulk Workflow Execution" tool in the Plug-in Store using the XRMToolBox application.
Let's look at a quick example of how the tool works. Say that you need to change the Owner of 10,000+ Case records. Follow the steps below:
1. Create an On-demand Workflow.
2. Create a Personal View or use an existing System View to pull your data set.
3. Open XRMToolBox.
4. Scroll and click the Bulk Workflow Execution.
5. Click Yes to connect to your Dynamics 365 organization.
6. Type your Organization URL.
7. Type your Username/Password and click Connect.
8. Type a Name for your organization after it successfully connects. NOTE: once the organization connection is established, XRMToolBox will open a new tab with the tool name and organization name you provided.
9. Select the On-Demand Workflow you created from the dropdown and wait for the tool to retrieve the applicable Views.
10. From the View list, select the System View or Personal View you are running the On-Demand Workflow against. Note: you should see the FetchXML Query populated in the area to the right after you select the View from the list.
11. Click Validate Query to verify the amount of records being pulled in the data set.
12. Determine your Batch Size and Interval Delay.
Note: if unsure, keep the default Batch Size at "200" and Interval Delay at "0" seconds
13. When ready, click Start Workflows.
14. The tool will run and will inform you of progress.
15. When finished, the tool will display a small window indicating the time it completed, how many records the workflow ran against, and number of errors as a result of the execution.
A good rule of thumb is allowing about 2 seconds per record for the tool to update a record. That would be 30 records per minute and 1,800 records per hour. Remember that this tool is completely automated! So, while the job runs you can leave your computer unattended or have it running in the background if multitasking.
Happy Dynamics 365'ing!