If you are using Power Automate (movement) and model-driven energy Apps, then (ideally) you’re alert to the “Common Data provider (present environment)” (CDS-ce) connector.

through this connector, there is certainly an “Expand Query” option. This web site post will assist explain just how to utilize this.

Note: take a look at Sara Lagerquist’s blog that is excellent “CDS vs CDS: exactly exactly What Connector can I used in energy Automate?“. This may assist you realize the distinction amongst the popular information provider connectors.

Let’s Dive In

Energy Apps Solution

To get going, We have currently developed a remedy in the charged power Apps manufacturer site called “PA Flows” (for “Power Automate Flows”). The step that is next be to generate a fresh movement inside the solution.

Note: For this instance, We have currently started a flow having a Flow Button since the trigger. You might use whatever trigger you desire in your flow(s).

The Flow Setup

Within the movement, We have a “List records action that is”renamed “List Opportunities”). In this instance i will be detailing the possibilities from Dynamics 365. In addition have simple ODATA “Filter Query” of “statecode eq 0” (0 = Active/Open).

Now, let’s take a look at that which we can grab through the production for the “List Records” action. I’d like to see if the opportunity’s can be got by me:

Associated Account’s title
Associated Owner’s email and name target
Associated Contact’s title

We inserted a “Create HTML Table” action to look at the array production through the “List Records”.

As you care able to see above, the Account Name just isn’t placed in the powerful content once I search with “account”.

Making Use Of “Expand Query”

Utilizing the flow that is basic, let’s make use of the “Expand Query” option when you look at the “List Records” action. First, you may be asking, “What do we put in this industry?” Great concern! And, there was a solution that is great.

I have created a simple FetchXML with “Opportunities” as the primary entity and have link entities to the Account, Contact, and User entities as you can see below. For every entity We have added in a few industries.

The step that is next pretty cool. In the FetchXML Builder device it is possible to view the energy Automate Parameters.

When this will be chosen, a little screen will appear utilizing the values you’ll need for energy Automate.

Notice the “Expand Query” values detailed? Take into account that right end associated with industry is chopping down that which you see. Just click from the “Expand Query” field plus it will be copied to your clipboard. We have pasted the worthiness into Notepad++ to demonstrate you the complete value.

You can view the schema title associated with the entity’s that are related accompanied by the chosen field’s schema title.

Now, let’s observe how this ongoing works inside Power Automate.

Back in energy Automate, i’ll newly paste in the copied “Expand Query” values to the “Expand Query” field in the “List Records” action.

Using this industry updated, this may now let us grab that given information inside our “Create HTML table” action.

First, let’s determine if the “Account Name” can be acquired. In the event that you remember, it wasn’t available early in the day.

As you can plainly see above, the “Account Name” has become available!

How about the “Contact Name”? We added this to the “Expand Query” field if you recall.

Yes! The Contact’s “Full Name” is visible and available to pick.

okay… how about the property owner information?

Now let’s finish upgrading the “Create HTML Table”.

Testing the Flow

Now that individuals have the movement arranged, let’s test drive it to start to see the production through the HTML Table.

We need as you can see, the table contains the information.

To help validate this, the output is put by me into a succeed file.

To Conclude

By leveraging the “Expand Query” option, we stored steps that are many energy trans dating Germany Automate. For instance, you would use the “Get a Record” action if you wanted to get the associated Account’s name. Nonetheless, because the possibilities come in a listing (array), when you link the “Get an archive” into the “List Records”, an “Apply to each” will appear. You will have to loop through most of the possibilities to link every one with all the proper Account to then obtain the Account Name.