Connecting Multiple SharePoint Lists Using Power Automate

Like (0) Share

Report

Posted on 28 Mar 2024 14:42:55 by ahemphill16

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.

All responses (3)

Answers (0)

lbendlin 7,842 Super User 2025 Season 1 on 28 Mar 2024 at 19:34:36

Like (0)

Report

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 4 on 28 Mar 2024 at 19:24:04

Like (0)

Report

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 7,842 Super User 2025 Season 1 on 28 Mar 2024 at 19:21:57

Like (0)

Report

Re: Connecting Multiple SharePoint Lists Using Power Automate

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