So what I'm trying to do is have a function where at a certain stage in my flow. It will check two SharePoint lists and look for matching values or unique ones. For example, I have 3 lists; Email List, Response List, No-Response List.
Email List (Primary) Response List (Secondary) No-Response List (Output)
Name Email Name Response Name Email
Tim 1@example.com Tim Yes Sarah 2@example.com
Sarah 2@example.com Ally Yes Mike 3@example.com
Mike 3@example.com Sam No
Ally 4@example.com
Sam 5@example.com
How my flow currently works is it sends an approval request to everyone on the email List. Their response will then be recorded in the secondary response list. The issue I'm having and would like the flow to do is then send a reminder email/notification to everyone that hasn't responded.
The few ways I've thought of how to potentially do it is 1st. Preferably the flow is able to determine who hasn't responded and can send a notification to them. 2nd, the other option I was thinking of is the flow can take the unique items from the two lists and add them to a new one (No-Response List) to then send an independent reminder email to that list. 3rd, the flow could add all Email List entries to the No-Response List and then delete any matches found between the Email (Primary) & Response (Secondary) list. (This would also require the No-Response list to delete and add the email entries at the start of the flow)
Any help would be appreciated!
