By using Power Automate (Flow) 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 shall assist explain simple tips to utilize this.
Note: take a look at Sara Lagerquist’s exemplary weblog called “CDS vs CDS: exactly just just What Connector can I use within energy Automate?“. This can assist you realize the distinction amongst the popular information provider connectors.
Let’s Dive In
Energy Apps Solution
To begin with, We have currently produced a remedy in the energy Apps manufacturer site called “PA Flows” (for “Power Automate Flows”). The step that is next be to generate an innovative new movement in the solution.
Note: For this instance, i’ve currently started a movement by having a Flow Button due to the fact trigger. You may use whatever trigger you need inside 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 possibilities from Dynamics 365. In addition have ODATA that is simple“Filter” of “statecode eq 0” (0 = Active/Open).
Now, let’s consider everything we can grab through the production associated with “List Records” action. I wish 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 name
We inserted a “Create HTML Table” action to see the array production through the “List Records”.
As you can plainly see above, the Account Name isn’t placed in the powerful content once I search with “account”.
Utilizing “Expand Query”
Using the fundamental movement setup, let’s make use of the “Expand Query” option into the “List Records” action. First, you might be asking, “What do we placed into this industry?” Great concern! And, there was a great solution.
While you can see below, we have actually developed a straightforward FetchXML with “Opportunities” whilst the main entity while having website link entities into the Account, Contact, and consumer entities. For every entity We have added in a few industries.
The next thing is pretty cool. In the FetchXML Builder device you are able to view the charged power Automate Parameters.
Once this can be chosen, a window that is small appear utilizing the values you will require for energy Automate.
Spot the “Expand Query” values detailed? Take into account that right end of this field is chopping off everything you see. Click on in the “Expand Query” field plus it will be copied to your clipboard. I’ve pasted the worthiness into Notepad++ to exhibit you the value that is full.
You can view the schema title for 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 shall paste into the newly copied “Expand Query” values to the “Expand Query” field in the “List Records” action.
With this particular industry updated, this may now let us grab that 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” is currently available!
How about the “Contact Name”? In the event that you remember, we included this towards the “Expand Query” field.
Yes! The Contact’s “Full Name” is noticeable and available to pick.
OK… how about the master 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.
We need as you can see, the table contains the information.
To advance validate this, the output is Philadelphia city free gay dating sites put by me into A excel file.
By leveraging the “Expand Query” option, we spared steps that are many Power Automate. As an example, you would use the “Get a Record” action if you wanted to get the associated Account’s name. Nevertheless, because the possibilities have been in a list (array), as soon as you link the “Get an archive” into the “List Records”, an “Apply to every” shall appear. You would need to loop through most of the possibilities to link each one of these with all the proper Account to then obtain the Account Name.