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

Condition vs. Switch in Power Automate: When to Use Each

A common question I hear from newer Power Automate users is when to use Condition vs Switch in the Control connector. Control is available in ...

2 days ago

Connection references and permissions in Power Automate

Have you ever battled with connection references in Power Automate? If not, you probably haven't worked on projects with multiple developers o...

2 days ago

How to Generate a Lead Summary with Copilot Actions using Power Automate Flow

Microsoft Copilot in Dynamics 365 Sales provides powerful AI-generated insights such as Lead summaries, opportunity summaries, relationship in...

6 days ago

Check if a file exists in SharePoint with Power Automate

Sometimes it is useful to create small helper flows to get a small tasks done. Today I needed to check if a file exists or not and all I had w...

10 days ago

Power Automate: BASE64 function

Power Automate's base64 function encodes strings for safe system-to-system transfers. Here's how it works, when you need it, and the 33% size ...

18 days ago

Microsoft Power Automate – Use Power Platform Environment variables in desktop flows

We are announcing the ability to retrieve Power Platform Environment variables directly through desktop flows in Microsoft Power Automate. Thi...

20 days ago

How to restrict Unwanted Power Automate flow execution

In Microsoft Dataverse, Power Automate flows are commonly used to execute business logic when records are created, updated, or deleted. They w...

21 days ago

Convert CSV files to JSON in Power Automate

How do you convert CSV files to JSON? When you have data in CSV format and you want to use this within Power Automate, there used to be a lot...

1 month ago

3 reasons to use the new designer in Power Automate

Hardly ever, I've seen a software change take so long for people to accept. How long will it be before developers just get on with as the new ...

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