I need help creating a conditional statement for a flow to send a notice (email) after filtering on IDs from two different SharePoint lists.
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
- 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
Would appreciate any helpful insight on how to create this flow!
Solved! Go to Solution.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.