Unanswered

Check two SharePoint Lists to see if Item Exists in One List, then Apply Function to Not Found Variables

(0) Share

Report

Posted on by MStark17

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!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

v-LilyW-msft on at

Like (0)

Report

Re: Check two SharePoint Lists to see if Item Exists in One List, then Apply Function to Not Found Variables

Hi @MStark17
Could you please share a bit more about your two list? It would be better to provide screenshots of the lists.
Best Regards.

Was this reply helpful? Yes No
MStark17 22 on at

Like (0)

Report

Re: Check two SharePoint Lists to see if Item Exists in One List, then Apply Function to Not Found Variables

Hi,

my post got marked as spam but it's since been corrected. I've edited my original post to better show what I'm trying to do now.

Was this reply helpful? Yes No
Verified answer

v-LilyW-msft on at

Like (0)

Report

Re: Check two SharePoint Lists to see if Item Exists in One List, then Apply Function to Not Found Variables

Hi @MStark17
I think it is possible to use only one list and add a column to the Email list, for example: Response.
You can create two flow.First flow,send approval email and update the item's Response column when the approval is completed use the approval outcome.
The second Flow checks the Response column, which are null values, if it is null, it means that the approval has not been completed, then sends an email to remind these user.
First Flow details:
Please set the apply to each to run concurrency.So that each approval can be carried out at the same time.
Save and run the flow.
If a user's approval is completed, the corresponding response will be updated to his item.
The second flow details:
Run Flow once a day at a fixed time.
After Flow runs, the user who have not approved will receive email reminders.
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No