inside this connector, there was an “Expand Query” option. This web site post will assist explain how exactly to utilize this.
Note: take a look at Sara Lagerquist’s exceptional weblog called “CDS vs CDS: exactly exactly just What Connector can I used in energy Automate?“. This may assist you realize the huge difference between your typical information provider connectors.
Let’s Dive In
Energy Apps Solution
To begin with, i’ve currently developed a remedy in the energy Apps manufacturer site called “PA Flows” (for “Power Automate Flows”). The step that is next be to produce a fresh movement inside the solution.
Note: For this instance, i’ve currently started a movement with a Flow Button since the trigger. You may use whatever trigger you want in your flow(s).
The Flow Setup
When you look at the movement, We have actually a “List records action that is”renamed “List Opportunities”). In this instance i will be detailing the Opportunities from Dynamics 365. We additionally have simple ODATA “Filter Query” of “statecode eq 0” (0 = Active/Open).
Now, let’s have a look at that which we can grab through the production for the “List Records” action. I would really like to see if I am able to obtain 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”.
As you can plainly see above, the Account Name is certainly not placed in the dynamic content once I search with “account”.
Utilizing “Expand Query”
Aided by the fundamental flow setup, let’s make use of the “Expand Query” option within the “List Records” action. First, you may be asking, “What do we placed into 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 single entity i’ve added in a few areas.
The next thing is pretty cool. Inside the FetchXML Builder device you can easily view the charged power Automate Parameters.
As soon as this will be chosen, a small screen will pop-up because of the values you will require for energy Automate.
Spot the “Expand Query” values listed? Take into account that right end associated with field is chopping down everything you see. Click on on the “Expand Query” field also it shall be copied to your clipboard. I’ve pasted the worthiness into Notepad++ to demonstrate you the value that is full.
You can view the schema title regarding the entity’s that are related followed closely by the chosen field’s schema title.
Now, let’s observe how this works inside Power Automate.
Back in energy Automate, i’ll paste within the newly copied “Expand Query” values to the “Expand Query” field regarding 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, this isn’t available earlier in the day.
As you can plainly see above, the “Account Name” has become available!
Think about the “Contact Name”? We added this to the “Expand Query” field if you recall.
Yes! The Contact’s “Full Name” is noticeable and available to pick.
okay… how about the dog owner information?
Now let’s finish upgrading the “Create HTML Table”.
Testing the Flow
Now that people have actually the movement put up, let’s test that to look at production through the HTML Table.
As you care able to see, the dining table provides the information we truly need.
To help validate this, the output is put by me into a succeed file.
To Conclude
By leveraging the “Expand Query” option, we stored numerous actions within energy Automate. For instance, you would use the “Get a Record” action if you wanted to get the associated Account’s name. Nonetheless, considering that the possibilities have been in a list (array), as soon as 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.
