Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Comparing Two List Arrays to Trigger Action (SPO Lists)



I need help creating a conditional statement for a flow to send a notice (email) after filtering on IDs from two different SharePoint lists. The goal is to allow a user group to know that an information product has had all pending reviews completed.


List A - IDs for information products Awaiting Reviewer Responses

List B - IDs for information products that still have Pending Reviews


If IDs from List A exist anywhere in List B then the flow needs to stop running. If items from List A do not exist in List B then the flow should trigger an email notice and update a field in List A (All Reviews Complete).


List A Example Output for IDs: 2, 5, 8, 10

- each instance is unique

List B Example Output for IDs: 2, 2, 7, 7, 7, 6, 10, 10

- each information product could have multiple reviews outstanding


Expected Results:

- ID # 2 and 10 would not run because they do exist in List B

- ID #5 and 8 would continue to run and successfully trigger the email because all reviews for those information products were completed (not in the pending status)


Would appreciate any helpful insight on how to create this flow!


Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,418)