Then(hopefully) you are aware of the “Common Data Service (current environment)” (CDS-ce) connector if you use Power Automate (Flow) and model-driven Power Apps.
through this connector, there 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 blog that is excellent “CDS vs CDS: exactly just exactly just What Connector can I used in energy Automate?“. This can assist you recognize the real difference between your typical information provider connectors.
Let’s Dive In
Energy Apps Solution
To begin with, We have currently produced a remedy inside the energy Apps manufacturer site called “PA Flows” (for “Power Automate Flows”). The next thing would be to generate a fresh movement in the solution.
Note: For this instance, I have currently started a movement with a Flow Button once the trigger. You might use whatever trigger you need inside your flow(s).
The Flow Setup
Within the movement, We have a “List records action that is”renamed “List Opportunities”). In this instance i will be detailing the possibilities from Dynamics 365. In addition have simple ODATA “Filter Query” of “statecode eq 0” (0 = Active/Open).
Now, let’s take a look at that which we can grab through the production associated with “List Records” action. I wish to see if I am Greeley CO escort review able to have the Opportunity’s:
- Associated Account’s title
- Associated Owner’s title and e-mail target
- Associated Contact’s title
