avoid repeated Lookup calls by saving the record result in a variable

Like (0) Share

Report

Posted on 18 Jul 2022 00:16:53 by mobilismexico

261

Say you have three lists, ListA, ListB, and ListC.

Some columns in ListA are my keys to retrieve data from Lists B and C. I use other ListA columns to set fill colors and things like that.

So far, I have been assigning Lookup results to individual variables, but I believe that the code would be cleaner if I could assign the whole Lookup result to a record variable, and the just use the record elements when I need them.

Is this possible? how?

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-yujincui-msft on 20 Jul 2022 at 08:25:30

Like (0)

Report
Re: avoid repeated Lookup calls by saving the record result in a variable

Hi @mobilismexico ,

Do you want to save a record as a variable?

I have made a simple test for your reference. I append a record to an array variable and then get the value of each field by expression.

1. Here is my SharePoint list.

2. Here is my Flow.

first(variables('VarRecord'))?['fieldname']

Result Screenshot:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No