Then(hopefully) you are aware of the “Common Data Service (current environment)” (CDS-ce) connector if you use Power Automate (Flow) and model-driven Power Apps.

in this connector, there clearly was an “Expand Query” option. This website post shall assist explain how exactly to make use of this.

Note: consider Sara Lagerquist’s exceptional weblog called “CDS vs CDS: just exactly exactly exactly What Connector must I used in energy Automate?“. This can assist you realize the real difference between your popular information provider connectors.

Let’s Dive In

Energy Apps Solution

To get going, We have currently produced a remedy inside the energy Apps manufacturer site called “PA Flows” (for “Power Automate Flows”). The next thing would be to produce a brand new movement in the solution.

Note: For this instance, We have currently started a movement by having a Flow Button because 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. We additionally have ODATA that is simple“Filter” of “statecode eq 0” (0 = Active/Open).

Now, let’s have a look at that which we can grab through the production regarding the “List Records” action. I wish to see if I’m able to have the Opportunity’s:

  • 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”.

I search with “account” as you can see above, the Account Name is not listed in the dynamic content when.

Making Use Of “Expand Query”

With all the flow that is basic, let’s utilize the “Expand Query” option within 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.

As you can see below, we have actually produced an easy FetchXML with “Opportunities” once the main entity and now have website link entities to your Account, Contact, and consumer entities. For every entity I have added in a few areas.

The alternative is pretty cool. Inside the FetchXML Builder device it is possible to view the charged power Automate Parameters.

As soon as this will be chosen, a window that is small pop-up with all the values you will require for energy Automate.

Spot the “Expand Query” values detailed? Take into account that right end associated with the industry is chopping down everything you see. Click on on the “Expand Query” field also it will be copied to your clipboard. I’ve pasted the worthiness into Notepad++ to demonstrate you the value that is full.

You can observe the schema title regarding the related entity’s field followed closely by the chosen field’s schema title.

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

Back in energy Automate, i am going to paste into the newly copied “Expand Query” values to the “Expand Query” field from the “List Records” action.

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

First, let’s determine if the “Account Name” is present. In the event that you remember, it wasn’t available earlier in the day.

As you care able to see above, the “Account Name” is currently available!

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

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

okay… how about the dog owner information?

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

Testing the Flow

Now it to see the output from the HTML Table that we have the flow set up, let’s test.

As you care able to see, the dining table provides the information we want.

To advance validate this, we place the production into a succeed file.

In Closing

By leveraging the “Expand Query” option, we stored steps that are many energy Automate. For instance, in the event that you desired to have the connected https://datingmentor.org/escort/garland/ Account’s title, you’ll make use of the “Get a Record” action. Nevertheless, considering that the possibilities have been in a listing (array), when you link the “Get an archive” to your “List Records”, an “Apply to every” shall appear. You will have to loop through most of the possibilities to link every one with all the proper Account to then have the Account Name.


Leave a Reply

Your email address will not be published. Required fields are marked *

ACN: 613 134 375 ABN: 58 613 134 375 Privacy Policy | Code of Conduct