News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows avoid repeated Lookup ...

Power Automate - Building Flows

Answered

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

(0) Share

Report

Report

Posted on 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?

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-yujincui-msft on at

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

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans