Loading...

Power Automate - [Dataverse]

Power Automate - [Dataverse]
Power Automate is used to automate operations through triggers and actions.
  • Triggers: Added, Modified, Deleted, Manual (Instant), Scheduled
  • Actions: List Rows, Get a Row by ID, Add a New Row, Update a Row, Delete a Row, Relate Rows, Unrelate Rows, Condition, Apply to Each, Do Until, Switch
  • Scope block in Power Automate is primarily used for error handling. It groups related actions together.

Triggers - 

Added, Modified, Deleted


Change type - Added / modified / delete
Table Name - Entity/Table name
Scope - User, BU, Parent Child BU, Organization  [Mostly we use Organization]
Select columns - Used for modified trigger to mention field names for which flow should trigger
Filter rows - To filter the record based on odata query
Run as - Flow Owner / Record owner / Modifying user [Mostly we use Flow owner]
-------------------------------------------------------------------------------------------------------------------------

Manual Trigger - To Trigger the flow manually. Flow can have input parameters.

-------------------------------------------------------------------------------------------------------------------------

Schedule / Recurrence - Flow will run at schedule time.
-------------------------------------------------------------------------------------------------------------------------

HTTP Trigger -
Flow can be called anytime by using flow URL [Not Recommended and used as it has security issues and it is blocked in many companies by DLP policies]
For learning purpose - Check how to call Flow using JavaScript.


-------------------------------------------------------------------------------------------------------------------------

Actions - 

Condition -  [If - Else]                                                          


Update a row [Table name, Row ID, Data]



Add a new row [Table Name, Data]



Delete a row - [Table Name, Row ID]

Get a Row By ID - [Table Name, Row ID, Columns]


List Rows - [Table Name , FetchXML / Odata query]




Apply To Each - For loop, e.g. Automatically added if you use list rows data anywhere

Do Until -  It executes the block until the condition is met. 
Count - 60 and Timeout - P1H. i.e. Do until can run max 60 times till 1 hour post that it will timeout and will not execute









Published on:

Learn more
Microsoft Dynamics CRM
Microsoft Dynamics CRM

Share post:

Related posts

How to Send Automated Emails from Dynamics 365 CRM Using Email Templates and Power Automate

Microsoft Dynamics 365 CRM provides robust email capabilities through Email Templates, enabling organizations to maintain consistent and profe...

2 hours ago

Your flow has a new trigger URL in Power Automate

Recently I've been receiving email reporting Your flow has a new trigger URL. In this post I will address this issue and how to avoid your flo...

3 days ago

Open an app in Power Automate Desktop

When you open an app in Power Automate Desktop, and you need to run this Power Automate Desktop flow multiple times it becomes important to ha...

4 days ago

Automating Business PDFs Using Azure Document Intelligence and Power Automate

In today’s data-driven enterprises, critical business information often arrives in the form of PDFs—bank statements, invoices, policy document...

4 days ago

Default retry settings in Power Automate

When actions in Power Automate flows go wrong, they may rerun depending on the failure occurred. One of the errors that may trigger is the 429...

8 days ago

Compress photos in Power Automate

One of my clients, takes many photos as part of their data entry process using a Canvas app. We need to compress the photos as the collected d...

9 days ago

Create MS Graph subscriptions in Power Apps without Power Automate

A while back I wrote a post about MS Graph subscriptions in Power Automate. Today I managed to do this directly within Power Apps.

11 days ago

Input and Output Parameters for Child Flows in Power Automate

In this post, I will look at the input and output parameter types for child flows. Recently I hit a couple of small issues with the various d...

15 days ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy