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

We inserted a “Create HTML Table” action to see 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”

Aided by the flow that is basic, let’s utilize the “Expand Query” option into the “List Records” action. First, you might be asking, “What do I put in this industry?” 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. For every entity i’ve added in a few industries.

The alternative is pretty cool. In the FetchXML Builder device you are able to view the energy Automate Parameters.

When that is chosen, a little screen will appear using the values you will require for energy Automate.

Spot the “Expand Query” values detailed? Take into account that right end for the industry is chopping down that which you see. Just click regarding the “Expand Query” field also it shall be copied to your clipboard. I’ve pasted the worthiness into Notepad++ to demonstrate you the value that is full.

You can view the schema title associated with related entity’s field accompanied by the chosen field’s schema title.

Now, let’s observe how this works inside Power Automate.

Back in energy Automate, i’ll paste within 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 given information inside our “Create HTML table” action.

First, let’s determine if the “Account Name” can be obtained. In the event that you remember, it wasn’t available earlier.

As you can plainly see above, the “Account Name” has become available!

How about the “Contact Name”? We added this to the “Expand Query” field if you recall.

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 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 put by me into a succeed file.

In Summary

By leveraging the “Expand Query” option, we spared numerous actions within energy Automate. For instance, in the event that you desired to obtain the linked Account’s title, you’d utilize the “Get a Record” action. Nevertheless, because the possibilities have been in a listing (array), when you link the “Get an archive” to your “List Records”, an “Apply to each” shall appear. You will have to loop through most of the possibilities to link every one with all the Account that is correct to obtain the Account Name.