If you are using Power Automate (movement) and model-driven energy Apps, then (ideally) you may be alert to the “Common Data provider (current environment)” (CDS-ce) connector.
through this connector, there is certainly an “Expand Query” option. This web site post will assist explain just how to utilize this.
Note: take a look at Sara Lagerquist’s blog that is excellent “CDS vs CDS: just just What Connector do I need to used in energy Automate?“. This may help you realize the real difference involving the popular information provider connectors.
Let’s Dive In
Energy https://datingmentor.org/germany-mature-dating Apps Solution
To begin with, i’ve currently developed a remedy in the charged power 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, We have currently started a flow by having a Flow Button since the trigger. You may use whatever trigger you desire inside 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 Opportunities from Dynamics 365. We additionally have simple ODATA “Filter Query” of “statecode eq 0” (0 = Active/Open).
Now, let’s consider that which we can grab through the output regarding the “List Records” action. I wish 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”.
I search with “account” as you can see above, the Account Name is not listed in the dynamic content when.
Utilizing “Expand Query”
Because of the fundamental movement setup, let’s utilize the “Expand Query” option within the “List Records” action. First, you might be asking, “What do we placed into this field?” Great concern! And, there was a great solution.
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. Read more