in this particular 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 Lagerquist’s exceptional web log called “CDS vs CDS: just exactly What Connector can I used in energy Automate?“. This may assist the difference is understood by you involving the typical information provider connectors.
Let’s Dive In
Energy Apps Solution
To begin with, 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 inside the solution.
Note: For this instance, i’ve currently started a movement by having a Flow Button once the trigger. You may use whatever trigger you want inside your flow(s).
The Flow Setup
Within the movement, We have a “List Records” action (renamed “List Opportunities”). In this instance i will be detailing the possibilities from Dynamics 365. In addition have ODATA that is simple“Filter” of “statecode eq 0” (0 = Active/Open).
Now, let’s take a look at that which we can grab through the production associated with the “List Records” action. I’d like to see if I am able to obtain the Opportunity’s:
- Associated Account’s title
- Associated Owner’s title and e-mail target
- Associated Contact’s name
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 just isn’t placed in the powerful content once I search with “account”.
Utilizing “Expand Query”
Aided by the basic movement setup, let’s make use of the “Expand Query” option within the “List Records” action. First, you might be asking, “What do we put in this field?” Great concern! And, there is certainly a solution that is great.
As you possibly can see below, we have produced an easy FetchXML with “Opportunities” whilst the main entity while having website link entities to your Account, Contact, and consumer entities. For every entity I have added in a few industries.
The next move is pretty cool. Inside the FetchXML Builder device it is possible to view the energy Automate Parameters.
When it is chosen, a window that is small pop-up using the values you will require for energy Automate.
Spot the “Expand Query” values listed? Remember that right end regarding the field is chopping down that which you see. Just click from the “Expand Query” field also it shall be copied to your clipboard. We have pasted the worthiness into Notepad++ to show you the value that is full.
You can observe the schema title for the entity’s that are related followed closely by the chosen field’s schema title.
Now, let’s observe how this ongoing works inside Power Automate.
Back in Power Automate, i shall newly paste in the copied “Expand Query” values to the “Expand Query” field regarding the “List Records” action.
With this specific 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” 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” is currently available!
Think about the “Contact Name”? In the event that you remember, we included this to the “Expand Query” field.
Yes! The Contact’s “Full Name” is noticeable 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 people have actually the movement arranged, let’s test drive it escort girl Gilbert to start to see the production through the HTML Table.
As you care able to see, the dining table provides the information we are in need of.
To advance validate this, we place the production into a succeed file.
To Conclude
By leveraging the “Expand Query” option, we spared steps that are many energy Automate. As an example, in the event that you desired to have the connected Account’s title, you’d make use of the “Get a Record” action. Nevertheless, considering that the possibilities come in a listing (array), as soon as you link the “Get an archive” into the “List Records”, an “Apply to every” shall appear. You will have to loop through all of the possibilities to link each one of these with all the Account that is correct to obtain the Account Name.
