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

Power Automate: skip Function

The "skip" function removes items from the front of an array in Power Automate. Learn edge cases, null handling, pagination patterns, and arra...

2 days ago

Power Automate: sort Function

Power Automate's sort function arranges arrays in ascending order by value or property. Learn usage tips, the string-vs-number gotcha, and how...

9 days ago

AI-Powered Approval System Using Copilot in Power Apps and Power Automate Flow

Modern approval processes are often slow, manual, and inconsistent, leading to delays, policy violations, and poor decision-making. In this so...

10 days ago

Power Automate: Office 365 Outlook - When a new event is created Trigger

The "When a new event is created" trigger monitors your Outlook calendar in Power Automate. Learn about UTC gotchas, duplicate triggers, and t...

14 days ago

[REDACTED] message when turning on a Power Automate flow

We all like useful error messages. How about the [REDACTED] Message when you turn on a flow? In this post you will find the steps to fix this ...

15 days ago

Power Automate: Do Until Action

The "Do Until" action loops in Power Automate until a condition is met. Learn its limits, why it always runs once, and how to avoid runaway lo...

15 days ago

Use Inventory to find your Power Automate flow?

How often do you want to find a flow, but you can’t remember which environment you created the flow in? It can be quite a

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