Hello,
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
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
Would appreciate any helpful insight on how to create this flow!
