By using Power Automate (movement) and model-driven energy Apps, then (ideally) you may be alert to the Common Data provider (present environment) (CDS-ce) connector.
- LuvFree dating
- By using Power Automate (movement) and model-driven energy Apps, then (ideally) you may be alert to the Common Data provider (present environment) (CDS-ce) connector.
in this particular connector, there clearly was an Expand Query option. This web site post shall assist explain just how to make use of this.
Note: take a look at Sara Lagerquists exemplary weblog called CDS vs CDS: exactly exactly What Connector must I used in energy Automate?. This can assist you realize the real difference between your typical information provider connectors.
Lets Dive In
Energy Apps Solution
To begin with, i’ve currently developed a remedy inside the charged power Apps maker site called PA Flows (for Power Automate Flows). The next thing would be to generate a unique movement inside the solution.
Note: For this instance, We have currently started a movement having a Flow Button once the trigger. You might use whatever trigger you want in your flow(s).
The Flow Setup
Into the movement, We have a List documents action (renamed List Opportunities). In this instance i will be detailing the possibilities from Dynamics 365. We additionally have simple ODATA Filter Query of statecode eq 0 (0 = Active/Open).
Now, lets take a look at that which we can grab through the production regarding the List Records action. I would really like to see if the opportunitys can be got by me:
- Associated Accounts title
- Associated Owners title and e-mail address
- Associated Contacts 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 powerful content when I search with account.
Utilizing Expand Query
Because of the fundamental movement setup, lets utilize the Expand Query option within the List Records action. First, you might be asking, What do we placed into this industry? Great concern! And, there is certainly 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 have added in a few areas.
The next thing is pretty cool. Inside the FetchXML Builder device you are able to view the charged power Automate Parameters.
As soon as this will be chosen, a window that is small pop-up utilizing the values you will require for energy Automate.
Spot the Expand Query values detailed? Take into account that right end regarding the field is chopping down that which you see. Just click on the Expand Query field plus it shall be copied to your clipboard. I’ve pasted the worthiness into Notepad++ to exhibit you the complete value.
You can view the schema title associated with the entitys that are related followed closely by the chosen fields schema title.
Now, lets observe how this ongoing works inside Power Automate.
Back in energy Automate, i am going to newly paste in the copied Expand Query values to the Expand Query field regarding the List Records action.
Using this industry updated, this can how does luvfree work 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 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 Contacts Full Name is available and visible to choose.
okay how about the master information?
Now lets finish upgrading the Create HTML Table.
Testing the Flow
Now that individuals have actually the movement put up, lets test that to start to see the production through the HTML Table.
We need as you can see, the table contains the information.
To advance validate this, the output is put by me into a succeed file.
By leveraging the Expand Query option, we stored steps that are many energy Automate. As an example, in the event that you wished to obtain the linked Accounts title, you’ll make use of the Get a Record action. Nevertheless, because the possibilities come in a listing (array), as soon as you link the Get an archive to your List Records, an Apply to every will appear. You would need 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.