inside this connector, there clearly was an Expand Query option. This web site post shall assist explain how exactly to utilize this.

Note: take a look at Sara Lagerquists blog that is excellent CDS vs CDS: just just exactly exactly What Connector do I need to use within energy Automate?. This may assist the difference is understood by you between your typical information provider connectors.

Lets Dive In

Energy Apps Solution

To get going, i’ve currently produced a remedy inside the energy Apps manufacturer site called PA Flows (for Power Automate Flows). The step that is next be to produce a brand new movement in the solution.

Note: For this instance, We have currently started a movement having a Flow Button because the trigger. You may use whatever trigger you need inside your flow(s).

The Flow Setup

Into the movement, We have actually a List records action that isrenamed List Opportunities). In this instance i will be detailing the possibilities from Dynamics 365. In addition have ODATA that is simpleFilter of statecode eq 0 (0 = Active/Open).

Now, lets take a look at everything we can grab through the production associated with the List Records action. https://datingmentor.org/latin-dating/ I wish to see if the opportunitys can be got by me:

• Associated Accounts title
• Associated Owners email and name target
• Associated Contacts title

We inserted a Create HTML Table action to see 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.

Utilizing Expand Query

Utilizing the fundamental movement setup, lets utilize the Expand Query option within the List Records action. First, you might be asking, What do we put in this industry? Great concern! And, there was a solution that is great.

As you possibly can see below, we have actually produced a straightforward FetchXML with Opportunities once the main entity while having website link entities to your Account, Contact, and consumer entities. For every entity i’ve 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.

As soon as this can be chosen, a window that is small appear because of the values you will require for Power Automate.

Spot the Expand Query values detailed? Take into account that right end of this industry is chopping down that which you see. Click on on the Expand Query field and it also will be copied to your clipboard. I’ve pasted the worthiness into Notepad++ to exhibit you the complete value.

You can observe the schema title associated with related entitys field accompanied by the chosen fields schema title.

Now, lets observe this works inside Power Automate.

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

With this specific industry updated, this can now let us grab that information inside our Create HTML table action.

First, lets determine if the Account Name can be acquired. In the event that you remember, it wasnt available early in the day.

As you can plainly see above, the Account Name is currently available!

How about the Contact Name? In the event that you remember, we included this into the Expand Query field.

Yes! The Contacts Full Name is noticeable and available to pick.

okay how about the property owner information?

Now lets finish upgrading the Create HTML Table.

Testing the Flow

Now we have actually the movement put up, lets test drive it to look at production through the HTML Table.

As you care able to see, the dining table contains the information we require.

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

In Summary

By leveraging the Expand Query option, we spared steps that are many energy Automate. As an example, in the event that you desired to obtain the connected Accounts title, you’ll utilize the Get a Record action. Nonetheless, considering that the possibilities have been in a list (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 each one of these with all the Account that is correct to obtain the Account Name.