Perform a changeset request in Dataverse connector in Power Automate

You must’ve noticed Perform a changeset request in the Dataverse connector in Power Automate.

Purpose of this Action is to perform batch of available Dataverse connector actions successfully or rollback the batch performed inside this changeset request.

Here’s what it does.

Perform a changeset request

Here’s how to use the connector action

Select Perform a changeset request in the Dataverse connector Actions list.
Now, since this works like a batch of operations to perform all actions successfully or “rollback” operations, you’ll see this working like a Scope but only for Dataverse actions.
You have the below Actions available to perform.
Now, let’s design an example changeset batch here.
First, I’ll create an Account and then a Contact.
When this Flow runs, for example, if the Contact creation fails, the Account creation too will be rollbacked unlike having these steps outside of the “Perform a changeset request” action.
Please note that the Outputs of the Changeset request itself or even within the steps within a changeset request cannot be captured or referred to in Dynamic Content.

Hope this helps!

Here are some Power Automate posts you want to check out –

Migrate Flow to latest Microsoft Dataverse connector

March 31, 2023 priyeshwagh777 Power Automate dataverse connector, migrate flow, migrate to the new dataverse connector, power automate dataverse connector

If you are using the legacy Dataverse connector which has the gray logo and looks like the below.

You can run Flow checker to identify if Power Automate can help you migrate the Flow to utilize the latest connector.

Flow checker message

Here’s what the old Flow looks like –

You would see the below message once Flow Checker suggests you changes –
Once you click on the “Open the migration assistant” link on the suggestion, it’ll pop-up a window to ask if you are ready to allow Migrating the Flow to the latest Dataverse connector.
Once you click on Migrate, it’ll start the migration process and based on how lengthy your flow is – in a few moments your new Flow will be ready.
So, once the migration is completed, you’ll see a message like this.
Once you click on Open the new flow, you’ll notice that the new Flow now has (Migrated) written in.
And once you click on Edit, you’ll see that the Flow step where old Dataverse connector was used has been replaced by the new Connector

Hope this helps!

Here are some Power Automate posts you want to check out –

Tracked Properties in Power Automate Flow Step

January 23, 2023 priyeshwagh777 Power Automate power automate flow, tracked properties, tracked properties in flow, tracked properties in flow step settings, tracked properties in power automate

If you are new to Power Automate and are wondering how Tracked Properties are and how they work?

Tracked Properties are data properties which are hidden away from the Input/Output sections of the Flow and which you can explicitly retrieve in a Flow Run.

Here’s a post to explain the same!

Tracked Properties

Below are what Tracked Properties are –

If you look at the Settings section of different Actions, you’ll see Tracked Properties.
And you’ll see Tracked Properties at the bottom once all Action specific Settings are listed.
Here, you can create and store your own properties and it’s value. It’s value could also be results of preceding steps or from expressions.
See example below –
Once you create these Properties, here’s how you can retrieve the same.

Retrieving Tracked Properties

Here’s how you can retrieve Tracked Properties –

You need to address using actions() method in Power Automate to read Tracked Properties of a certain step.
Hence, the syntax is “action('<stepname>')?['TrackedProperties']“
You can store it in an Object variable and see the result as below
Or, if you want to retrieve only a specific property, you can mention the same in the expressions itself.
And it’ll show up like this (In anything stores Integer / String)

Hope this helps!

Here are some Power Automate posts you want to check out –

Thank you!

Instant Cloud Flow asking for Location Services to be turned on | [Quick Tip]

October 29, 2022 priyeshwagh777 Power Automate location for instant cloud flow, location services for flow, power automate instant cloud flow

If you are using Instant Cloud Flows in Power Automate, you must be asked the below –

That’s because Instant Cloud Flow needs Location Services to be on for Power Automate.

Turn On Location Services

Here’s how you can turn on Location Services.

If you click on the “Lock” icon on the Chrome (or other browsers), you’ll see Location is turned off. This is when you would have initially denied sharing location.
All you need to do is turn this on. Flip the switch!
And now when you Run the Flow again, you’ll notice that the Location services has passed on the Location details to the trigger of the Flow i.e. Instant Flow trigger.

Hope this helps!

Here are some Power Automate posts you want to check out –

Thank you!

Check which Power Automate or Power Apps Licenses are assigned to you | [Quick Tip]

October 28, 2022 priyeshwagh777 Microsoft PowerApps, Power Automate licensing, Power Automate, power automate licenses

In case you are using Power Automate for your own use or asked to build something for the team, here’s how you can check what capabilities you are entitled to –

Check Licenses in Power Automate

Here’s how you can check licenses assigned to you in Power Automate –

When in Power Automate, click on the Gear icon.
Now, select View My Licenses.
Here, you’ll clearly see all the licenses and the capabilities you have with the Power Automate license assigned to you.
Another example is a User with only Power Automate Free license assigned to them. This is what they will see –
This simple and clear distinction helps you identify with the capabilities you have in Power Automate.
Here’s the Power Automate Pricing Link provided in the “Learn how to add capabilities” section at the bottom.
https://powerautomate.microsoft.com/en-us/pricing/
Here’s a Bonus! Same applies for Power Apps as well. If you are in Power Apps (https://make.powerapps.com/) or in the App Designer in a Canvas App, you can see the Plan(s) option under the Gear Icon.
And you’ll see the Capability available to your user.

Hope this helps!

Here are some Power Automate posts you want to check out –

Thank you!

Format Data by Examples in a Flow [Preview] | Power Automate

October 17, 2022October 17, 2022 priyeshwagh777 Power Automate format data by examples, format data by examples in flow, format data in power automate

Here’s an exciting update users are starting to see in Oct 2022. Is to Format Input data based on examples i.e. generating Expressions instead of writing them yourselves in Power Automate!

At the time of this post, this is in Preview and hence, please consider that this might or might not make it to final release and hence, not recommended for Production use!

Let’s see how this works!

Expressions using Data Samples in Power Automate

Here’s how you can generate Expressions that have been generated from Examples you provide –

In Dynamic Content, go to Expressions, you’ll see the Format data by examples option at the top.
I’m passing Date in the Flow as below –
This will open up a pane on the right hand side to select the data variable for which the expression has to be generated.
I want to format a Date from the Inputs in a certain way. Hence, I’ll select Date from the Pane which has opened up.
Upon selection, I’ll provide some examples on what values can come in and what should it be translated to.
Here, I’ll enter some examples on how the input date can be expected to which what the output format should be desired.
Once I provide a few examples, I can click on Get expression for the Flow to generate a custom expression for me based on the examples I provided.
Upon clicking Get expression, the Flow will generate a custom Expression for you which you can test/copy right away.
Note that in the above, the key-button-date is set, you need to set this to the actual field
Here’s an example which I’m testing –

And it produced the correct result –
So, I’ll click on Apply.
You’ll be asked confirmation before Applying this formatting –
Once you confirm, the Expression will be generated.
And when you test the actual Flow, it’ll expect the value based on how you tested the Expression and produce the result –
In this case, the key-button-date i.e. the current Date was formatted. Hence, the current date will be returned.
And the answer is as below –

Hope this was useful!!

Other Examples

Currently, below are the types of formats supported –

Date
Text
Number

Text Example

Here’s a Text based example you can think of –

In a Text based Example, I want only first 3 letters of a City.
Here’s the expression Generated which I can check –
And like the main example above, this expression can be applied!

Number Example

Here’s a quick number example you can think of –

Let’s say you want to format a number in a phone format or currency –
And the expression will be generated for the same –

Here’s Microsoft Documentation on the same – https://learn.microsoft.com/en-gb/power-automate/format-data-by-examples?WT.mc_id=DX-MVP-5003911

Hope this was useful!

Here are some Power Automate posts you want to check out –

Thank you!

Using Environment Variables in Power Automate and Canvas Apps

October 16, 2022 priyeshwagh777 Microsoft PowerApps, Power Automate, Power Platform environment variable in power automate, environment variables in canvas app, environment variables in flow, environment variables in power platform

Here’s how you can use Environment Variables in your environment in Power Automate and Canvas Apps!

In case you are looking to create Environment Variables, here’s the post: Environment Variables in Power Apps and Power Automate

Power Automate

Here’s how you can use Environment Variables in a Flow –

You can’t use/access Environment Variables in a Flow which is not in a solution –
Environment Variables are accessible in the Dynamic Content section on the very top of the list. [Since the below Flow is outside a Solution, you can’t see the Environment Variables]
Now, this Flow is within a Solution –
And then you access the Dynamic Content, you can see the Environment Variables.
And when you Run the Flow, the Environment Variable will show the value based on the Data Type set for the variable at appropriate places –

Canvas Apps

Unlike Power Automate Flow, Environment Variables in Canvas Apps can be utilized even if the Canvas App was created outside a solution –

In a Canvas App, click to Add Data Source.
On the Environment Variable Definitions/Values is added to the Canvas App as Data Sources, let’s take a simple Text control to read the Value from the Environment Variable used in the above Flow example –
I’ll use Lookup() function in Power Automate to fetch the value of the Environment Variable by it’s Schema Name –
Even if you only added Environment Variable Values table as Data Source, the Environment Variable Definition too will be added once you use the Lookup() function to fetch the value.

Hope this was useful!

Here are some Power Automate posts you want to check out –

Thank you!

Math Functions examples in Power Automate Flow

October 10, 2022 priyeshwagh777 Power Automate all math functions in flow, math functions in flow, math functions in power atuomate

Here are the examples of how you can use the Math Functions from Dynamic Content in a Power Automate Flow –

In this example, I’ll use the below Inputs to perform the Math Operations on and I’ll have the Math Functions perform in the Example of the functions shown below –

Min()

Minimum gives out the smallest value in the Array of numbers.

Here, I’ve created an array of numbers and from this, I’m selecting the minimum value.
And the result is as below –

Max()

Inversely as the Min() function above, the Max function will return the highest number from the Array or Collection –

Here’s how I use the Max function –
And the result of the Max function is as below –

Add()

As it suggests, this is the addition function which will add the 2 numbers provided as arguments –

In the variable, I’ll look for add and enter the 2 arguments from the Manual Trigger i.e. passing values while running the Flow.
And as you can see below, I’m using add() function and passing the parameters separated by a comma.
Then, I’m passing the below arguments when I run the Flow.
And then I run the Flow, the result is as below –

Sub()

As the function suggests, you can subtract number 2 from number 1. Here’s an example –

In the below Sub() function, I can see
And when I pass the below arguments 20 and 5 –
And the result will be 20 – 5 = 15.

Rand()

Rand() function will give out a random number from the collection at each run. Hence, the result will vary on each run –

I’m providing the start number range and the end number range. And the function will select the a random number from within the range –
So, when I run it for the first time, I’ll get a number
And when I run it one more time, I’ll get a different number.

Mul()

Mul() function will multiple the 2 numbers passed in the arguments –

I’m passing the 2 arguments within the function itself like I did for some of the above functions.
And the result will be as follows –

Div()

Div function will divide the first number by the second one –

In this example, I’m providing the
And the result in this case is 25.

Mod()

Mod() function will give the modulo / modulus or the division happening between the dividend and the divisor i.e. you’ll get the remainder value –

I’m supplying the below parameters which will give a modulus.
And the result obtained is the remainder of the division –

Range()

Range() function will generate a range between –

The 2 arguments required by range() function are startIndex and count. Count meaning how many numbers you want in the array.
Notice the type of the variable has been changed to an Array now.
And the result is the below Array with 6 items in the Array starting from value 2.

Hope this was useful!

Here are some Power Automate posts you want to check out –

Thank you!

Get Display Name of the current Flow in Power Automate

October 8, 2022 priyeshwagh777 Power Automate name of the flow in power automate, power automate flow, workflow function in power automate

If you are working on complex Flows and need to identify which Flow a certain operation is being performed from –

Example, you are working on some Account Processing Flow you designed for Dataverse tables and there are several Flows for the Account table, but you want to start logging errors from different Flows for developer reference.

workflow() function

Here’s how you can use the workflow() function in Power Automate Flow to get the name of the current Flow –

Here’s the name of the Flow which we are intending to get in the Flow run itself.
In this example, I’m initializing a variable of type String to Demonstrate this
Now, you have workflow() function in the Expressions area in Dynamic Content in your Flow step.
Once you select the workflow() function, you can continue to type in even though you are not seeing auto-complete options. Type .tags.flowDisplayName further as shown below
And click OK, make sure by hovering that the expressions is added.
And when you Run the Flow to test, you can get the Name of the Flow itself.
Also, you can get the other properties from the workflow() function as well. Here’s an example when you just use workflow() function and see the results –

Hope this was useful!

Here are some Power Automate posts you want to check out –

Thank you!

Create a GUID in a Flow | Power Automate [Quick Tip]

October 7, 2022 priyeshwagh777 Power Automate guid, guid in flow, Power Automate

Here’s how you can create a GUID in a Flow!

GUID Function

Here’s how you can use the “guid()” method in Power Automate Flow to create a new GUID every time it’s run –

I’m using an instant Flow to demonstrate this. And I have a variable where I’m adding a guid() method from the Dynamic Content area.
Just using this, it’ll generate a unique GUID on each run.
Below are some examples which were generated on each run.

Hope this was useful!

Here are some Power Automate posts you want to check out –

Thank you!

D365 Demystified

A closer look at Microsoft Dynamics 365.

Power Automate

Perform a changeset request in Dataverse connector in Power Automate

Perform a changeset request

Migrate Flow to latest Microsoft Dataverse connector

Flow checker message

Tracked Properties in Power Automate Flow Step

Tracked Properties

Retrieving Tracked Properties

Instant Cloud Flow asking for Location Services to be turned on | [Quick Tip]

Turn On Location Services

Check which Power Automate or Power Apps Licenses are assigned to you | [Quick Tip]

Check Licenses in Power Automate

Format Data by Examples in a Flow [Preview] | Power Automate

Expressions using Data Samples in Power Automate

Other Examples

Text Example

Number Example

Using Environment Variables in Power Automate and Canvas Apps

Power Automate

Canvas Apps

Math Functions examples in Power Automate Flow

Min()

Max()

Add()

Sub()

Rand()

Mul()

Div()

Mod()

Range()

Get Display Name of the current Flow in Power Automate

workflow() function

Create a GUID in a Flow | Power Automate [Quick Tip]

GUID Function

Perform a changeset request

Share this:

Like this:

Flow checker message

Share this:

Like this:

Tracked Properties

Retrieving Tracked Properties

Share this:

Like this:

Turn On Location Services

Share this:

Like this:

Check Licenses in Power Automate

Share this:

Like this:

Expressions using Data Samples in Power Automate

Other Examples

Text Example

Number Example

Share this:

Like this:

Power Automate

Canvas Apps

Share this:

Like this:

Min()

Max()

Add()

Sub()

Rand()

Mul()

Div()

Mod()

Range()

Share this:

Like this:

workflow() function

Share this:

Like this:

GUID Function

Share this:

Like this: