Showing results for 
Search instead for 
Did you mean: 
Advocate I
Advocate I

How do I compare one line in a list with all the lines in another list?

How to compare two lists using flow?

Example: I have a list 1 and a list 2 on the sharepoint, I need to compare each line in list 1 with all the lines in list 2.

So, how would I compare each row in list 1 with all the rows in list 2?

I want to check if the line exists, and update it. If it does not exist, insert the line. I'm doing this by comparing it by the unique id, but, it is comparing each row of the first table, with each row of the second, and what I want is for the flow to check every second table first, and then create or update something.


Helpful resources

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (45,341)