Answered

Fetch record from lookup field of another lookup field in a record in the MS FLow

(0) Share

Report

Posted on by Inkey Solutions

Hello,

I have an existing MS Flow which is having a "List records" action of D365 CRM, which is fetching the records of an entity "QPR". In the next step, I am creating a CSV file using the ODATA query.

For example:-

if(empty(item()?['field_name']),'',item()?['field_name'])

Now, the problem is that I am not able to access the grand-child lookup record.

For example:-

There is a Lookup field named "A" in the entity "QPR". And, I want to access the "ABC" field of the Lookup "B" in the Lookup "A" record in the "QPR" entity.

Is it possible to get this level of record in MS Flow? How could I achieve it?

All responses (2)

Answers (1)

Verified answer

v-bacao-msft on at

Like (0)

Report
Re: Fetch record from lookup field of another lookup field in a record in the MS FLow

Hi @Ancy ,

You could refer to the following methods to achieve your needs.

For example, I want to get the email of each owner in the Account entity. Owner is a lookup column, which comes from the User entity.

First, define an array variable to store the data needed in the table.

Then use Get record to get the corresponding field value in the lookup table, configure lookup column id in Item identifier.

Then append the value to be displayed in the table to the array variable.

Image reference:

Details in Apply to each:

Hope this helps.

Best Regards,
manuelstgomes 6,625 on at

Like (0)

Report

Re: Fetch record from lookup field of another lookup field in a record in the MS FLow

Hi @Ancy

I had the same issue in the past and it's not possible. However you can create a new column in the "father" list that contains the information that you need from the "grand-father". Then you need a Power Automation that updates those fields periodically so that you can use them in your Power Automation.

It's kind of hacky but nested lookups are not possible so it's the only way I found that I could get that information.

Hope this helps you.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers
Manuel