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

Substring vs Slice in Power Automate

Power Automate has quite a few string functions that can help you sort out textual issue. Two of these functions are Substring and Slice. Do y...

11 hours ago

Power Automate – Debug easily into condition actions at runtime

We are announcing the ability to debug condition actions by displaying values passed into the dynamic content and expressions at runtime in Po...

13 hours ago

Run a generative action in Power Automate

Recently the Run a generative action was added to Power Automate. To make this action work is not as easy as you might hope.

1 day ago

Send community news by email using Power Automate

Yesterday on Reddit I was asked about how to collect and send community news articles from websites using Power Automate so that news letters ...

1 day ago

4 ways to filter data in Power Automate

Yesterday, I looked at how to filter data when making an API call using the HTTP action and noticed that filtering data isn't always straight ...

3 days ago

Segments in Customer Insights - Journeys: Bulk delete with Power Automate

Currently its not possible to delete segments more than one at a time from the view in Dynamics 365 Customer Insights - Journeys. Why? I don’...

8 days ago

Organise UI Elements in Power Automate Desktop

In recent months, I have begun using Power Automate Desktop for automated testing within Power Apps. In this post I will have a look at how w...

9 days ago

How to read Global Choice/Optionset Metadata from Dataverse from Power Automate using HTTP Dataverse WebAPI Call

In this blog You will learn How to read Global Choice/Optionset Metadata from Dataverse from Power Automate using HTTP Dataverse WebAPI Call. ...

10 days ago

How to read Local Choice/Optionset Metadata from Dataverse from Power Automate using HTTP Dataverse WebAPI Call

In this blog You will learn How to read Local Choice/Optionset Metadata from Dataverse from Power Automate using HTTP Dataverse WebAPI Call. W...

10 days ago

3 approaches to reshape data in Power Automate Efficiently

Earlier this week I was asked to reshape data in Power Automate. Having an array of data that needs to be reshaped just sot that an API can ta...

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