Looking for PowerObjects? Don’t worry, you’re in the right place! We’ve been part of HCL for several years, and we’ve now taken the final step in our acquisition journey: moving our website to the HCL domain. Nothing else is changing – we are still fanatically focused on Microsoft Business Applications!

PowerObjects Blog 

for Microsoft Business Applications

|

How to Bulk Update CRM Records Using the Bulk Workflow Execution Tool

Post Author: Joe D365 |

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.

bulk workflow execution

2. Create a Personal View or use an existing System View to pull your data set.

bulk workflow execution

3. Open XRMToolBox.

4. Scroll and click the Bulk Workflow Execution.

5. Click Yes to connect to your Dynamics 365 organization.

bulk workflow execution

6. Type your Organization URL.

bulk workflow execution

7. Type your Username/Password and click Connect.

bulk workflow execution

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.

bulk workflow execution

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.

bulk workflow execution

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.

bulk workflow execution

14. The tool will run and will inform you of progress.

bulk workflow execution

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.

bulk workflow 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.

That's it! For more Tips & Tricks and other educational materials on Dynamics 365, check out our blog.

Happy Dynamics 365'ing!

Joe CRM
By Joe D365
Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.

PowerObjects Recommends