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. 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!
User | Count |
---|---|
25 | |
14 | |
12 | |
10 | |
9 |
User | Count |
---|---|
51 | |
29 | |
28 | |
24 | |
22 |