Using Lookup reference

(0) Share

Report

Posted on by Martin_W

373

Hello all

I have two tables - one for Clients which has their address, contact name etc.

The other table lists items of equipment which need to be inspected. It contains things like the equipment name, manufacturer name, serial number and the name of the Client that owns it, via a Lookup to the Client table.

In PowerApps, if I have a gallery of equipment (i.e. the data source is the second table), then I can put a text box in the gallery and populate with;

Gallery1.Selected.Client.Address

Although the Gallery is only linked to the Equipment table I can display the address of the client by using Power Apps to address the other table via the lookup.

I'm looking to do the same thing in Power Automate. I start my Flow by fetching rows from the Equipment Dataverse table. I'm then building an HTML string for a report (which I'll convert to PDF later).

I can insert the name of the owning client easily enough using dynamic content, but what I can't see how to do is to grab the client address from the other table via Lookup.

Any ideas please?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

v-jefferni on at

Like (1)

Report

Hi @Martin_W ,

In Power Automate, you can get the Value from a LookUp column and also use this GUID value as the Id to get a record from source table:

Best regards,

Was this reply helpful? Yes No
Verified answer

ivan_apps 2,187 Moderator on at

Like (0)

Report

You can do the method that @v-jefferni suggested and that is ok. Common and easy to use.

Another method to use is the “Expand Query” option. This will “expand” a lookup for you to bring in properties from that lookup, without requiring you to perform another query. Take a look at this article for how to use the expand query, as it expects a specific format to properly return the data.

https://www.crmcrate.com/power-automate/dynamics-365-understanding-using-the-expand-query-in-power-automate/#:~:text=If%20you%20are%20utilizing%20the,values%20of%20the%20related%20entities.

prefix_YourTableSchemaName($select=prefix_YourColumnName)

Was this reply helpful? Yes No
Martin_W 373 on at

Like (0)

Report

Hi @v-jefferni

I think the thing I'm stuck with is limiting the amount of data returned by the "List Rows" step. I only want the rows where the "Site" column match a name, but the Site column is the lookup.

thanks,
Martin

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (1)

Report

Hi @Martin_W ,

Please check the video and see how to use odata filter query for Dateverse LookUp columns:

Explainer (EN) (youtube.com)

Best regards,

Was this reply helpful? Yes No