web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

VLOOKUP between two sharepoint lists

(0) ShareShare
ReportReport
Posted on by 32

I have two lists- List A and List B. List A is a population of projects with contact information (e.g. project code, project title, email, name). List B is a population of survey results from Microsoft Forms with the persons email and name as well. 

 

When a survey is completed, the results are populated in List B. If the email in List B matches the email in List A, I want the project code from List B pulled into List A. 

 

So far my flow is this: 

When an item is created in List B

Get items from List B 

Get items from List A 

 

The flow continues below. It fails in the "Update Item" portion and says list item cannot be found.

 

gabequinn___0-1684187103383.png

 

 

I have the same question (0)
  • Verified answer
    Pstork1 Profile Picture
    68,271 Most Valuable Professional on at
    Re: VLOOKUP between two sharepoint lists

    Power automate doesn't have a Lookup function.  But you can do a Get items on list A using an OData query on the email from List B.  Then use First() on the array that is returned and append ?['fieldname'] to the first to get the value from the first record.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 722 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 461 Moderator

#3
developerAJ Profile Picture

developerAJ 283

Last 30 days Overall leaderboard