Skip to main content
Community site session details

Community site session details

Session Id : WiPSlkdMsLReoeX/1aaenC
Power Automate - Building Flows
Unanswered

Connecting Multiple SharePoint Lists Using Power Automate

Like (0) ShareShare
ReportReport
Posted on 28 Mar 2024 14:42:55 by 4

Hello,

 

I am attempting to build a power automate flow to serve as a substitute to the VLOOKUP function in excel. My logic is as follows:

 

1. When an item is created in List A,

2. Check to see if that same item is in List B,

3. If True, populate column 6 in List B with information from column 6 in List A,

4. If False, do nothing.

 

I have a drafted the flow pictured below. But when it runs, it updates column 6 in List B for all of the rows instead of the row that matches List A, despite the conditional logic that should check to see if the data in column 1 of both lists is the same.

 

Building relationships between SharePoint Lists is crucial for data entry efficiency, so any support you can provide would be greatly appreciated.

 

 

image.png

  • lbendlin Profile Picture
    8,065 Super User 2025 Season 1 on 28 Mar 2024 at 19:34:36
    Re: Connecting Multiple SharePoint Lists Using Power Automate

    I would still at least do an ODATA query if I were you. it will still be faster than having to iterate through.

  • ahemphill16 Profile Picture
    4 on 28 Mar 2024 at 19:24:04
    Re: Connecting Multiple SharePoint Lists Using Power Automate

    Each list is less than 100 records. Which is why I haven't used a query.

  • lbendlin Profile Picture
    8,065 Super User 2025 Season 1 on 28 Mar 2024 at 19:21:57
    Re: Connecting Multiple SharePoint Lists Using Power Automate

    How big are your lists?  Have you considered using ODATA and/or Graph API instead?

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1