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

We need to talk about... Power Automate... Licensing

Next in my blog, I am going to cover a topic that has come up several times in recent conversations with clients.....Microsoft Licensing! part...

1 day ago

Flows getting triggered multiple times / missing callbackregistration record – Power Automate / Dataverse

Recently, we observed that one of our flows was getting triggered multiple times in our UAT environment; however, the flow was working properl...

2 days ago

Power Automate – Information about ‘Retry with AI vision’ functionality in Power Automate for desktop

We are announcing the introduction of the Retry with AI vision feature in error handling for UI and browser automation within Power Automate f...

3 days ago

How to Automate Post-Case Resolution Surveys in Dynamics 365 with Copilot and Power Automate (Preview)

Exceptional customer service doesn’t end when a support ticket is closed. In many cases, the most insightful feedback comes after the re...

3 days ago

Power Automate with a Service Principal (App Registration)

A “service account” for Power Automate with a Service Principal (App Registration) Dataverse—implemented as…

3 days ago

Power Automate – Reference previous prompts in Copilot for Power Automate desktop

We are announcing the ability to reference previous prompts in Copilot for Power Automate desktop in Power Automate. This feature will reach g...

3 days ago

Power Pages Solution Architecture Patterns: When to Use Liquid vs. JavaScript vs. Power Automate

In Power Pages, you can implement logic in multiple layers — Liquid (server-side), JavaScript (client-side), or Power Automate (external workf...

8 days ago

New Tool : ‘Cloud Flow Viewer’ for Power Automate Solutions

I’ve added Cloud Flow Viewer tool to my hobby project JayVish Problem Statement: Let’s say you’ve received a Dataverse solution—managed ...

9 days ago

Advanced Error Handling Patterns in Power Automate

When you start building a lot of Flows, you’ll start noticing that only checking values and if the actions succeeded only takes you so f...

9 days ago

Power Automate Cloud Flow | Disable an action

Did you know you can disable a flow action without removing it entirely by turning on the Enable Static Result toggle? When the flow runs, thi...

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