News and Announcements icon

Power Platform CommunityForums Power Automate - General Discussion Compare 2 Sharepoint L...

Power Automate - General Discussion

Unanswered

Compare 2 Sharepoint Lists (with a reference column) and then update records & create item if it doesnt exist

(0) Share

Report

Report

Posted on by OJBridger

32

Hi all, I've been scratching my head on this for a while, I've only made it work in the very slow inefficient way with 10000+ API calls and 1-4hr Flow run times.

I have 2 Sharepoint lists.

List 'A' is a live list that is in constant use and is for capturing data inputs. It has a UniqueID calculated column in the format of MM/dd/yyyy&OrderNumber. i.e: 04/30/20232056

List 'B' is a source list that gets updated weekly with true data. It has the same UniqueID calculated column with the format of MM/dd/yyyy&OrderNumber. i.e: 04/30/20232056

I now need to match items in the lists on this 'UniqueID' value, and then update List 'A' with extra data from List 'B'. The data in question that needs updating is timestamp data such as order placed, order fulfilled etc etc. Plus I need to do these features:

If an Item is found in 'A' and not 'B', it needs deleting
If an Item is found in 'B' and not 'A', it needs a record creating in List 'A'

I don't know the best way of doing this, but I know looping through nested For Each loops is not the best way to do it.

Any help would be great!

All responses Img

All responses (1)

Answers Img

Answers (0)

OJBridger 32 on at

Like (0)

Report
Re: Compare 2 Sharepoint Lists (with a reference column) and then update records & create item if it doesnt exist

Bumping post:

I think I know the steps in theory:
Get Items List A
Get Items List B
Put both into filtered Arrays
Combine Arrays into a single Array based on uniqueID
Loop over combined Array to Update Item in list A
If item in exists in B but not A, create item in list A
Lastly, delete any items from A that are not in B (no UniqueID match)

Helpful resources

News and Announcements

Upwork and Microsoft Power Platform Partnership

Welcome to the Power Platform Communities

Check out the New Agent Creator Community

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 566 Super User 2025 Season 1

#2

David_MA 516 Super User 2025 Season 1

#3

stampcoin 492

Last month Overall leaderboard

Featured topics

How to Ask for Help with Your Power Automate Workflow

Product updates

Microsoft Power Platform Community release plans