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.
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.