How To Automatically Calculate a Rollup Column with Power Automate

Rollup columns in Dataverse are powerful, but they only update hourly by default. In this tutorial, learn how to use Power Automate to recalculate rollup columns automatically whenever a record is modified. Follow along as we create a flow using the Dataverse Web API to ensure instant updates and improved reporting. This step-by-step guide is perfect for anyone looking to enhance their Dataverse workflows.

Base structure for your URL to force a RollUp: Your_environment_Web_API_endpoint/CalculateRollupField(Target=@EntitySetName,FieldName=@FieldName)?@EntitySetName={'@odata.id':'your_table(GUID of your record)'}&@FieldName='your_column_logical_name'

👉 On-Demand Learning - Start With The FREE Community Plan: https://prag.works/odl-trial-yt

🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/

00:00 - Introduction to Rollup Columns in Dataverse
00:33 - The Problem with Default Rollup Timing
01:03 - Setting Up a Model-Driven App Example
01:35 - Manual Recalculation of Rollup Columns
02:15 - Creating an Automated Cloud Flow
03:07 - Setting Triggers for Record Updates
03:44 - Using the Dataverse Web API
05:29 - Configuring the HTTP Request
06:10 - Finding the Entity Set Name and Field Name
07:45 - Building the Flow with Dynamic Content
08:42 - Testing the Automated Flow
09:34 - Viewing Real-Time Rollup Updates
10:10 - Closing

Let's connect:

✔️Discord: https://prag.works/yt-discord
✔️Facebook: https://prag.works/yt-fb
✔️Instagram: https://prag.works/yt-insta
✔️LinkedIn: https://prag.works/yt-li

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#PragmaticWorks