web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Check two SharePoint L...
Power Automate
Answered

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

(0) ShareShare
ReportReport
Posted on by 22

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:
I have the same question (0)
  • v-LilyW-msft Profile Picture
    Microsoft Employee on at

    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. 

  • MStark17 Profile Picture
    22 on at

    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.

  • Verified answer
    v-LilyW-msft Profile Picture
    Microsoft Employee on at

    Hi @MStark17 

    I think it is possible to use only one list and add a column to the Email list, for example: Response.

    vLilyWmsft_0-1634275737335.png

    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:

    vLilyWmsft_1-1634276100620.png

    Please set the apply to each to run concurrency.So that each approval can be carried out at the same time. 

    vLilyWmsft_2-1634276154555.png

    vLilyWmsft_3-1634276178019.png

    vLilyWmsft_4-1634276306830.png

    vLilyWmsft_5-1634276366991.png

    Save and run the flow.

    If a user's approval is completed, the corresponding response will be updated to his item.

    vLilyWmsft_6-1634276488816.png

    The second flow details:

    Run Flow once a day at a fixed time.

    vLilyWmsft_7-1634276566404.png

    vLilyWmsft_8-1634276935589.png

    vLilyWmsft_9-1634276947662.png

    After Flow runs, the user who have not approved will receive email reminders.

    vLilyWmsft_10-1634277019014.png

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 77 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 68

#3
Expiscornovus Profile Picture

Expiscornovus 56 Most Valuable Professional

Last 30 days Overall leaderboard