Unanswered

Check SharePoint List against names of people in Excel

(0) Share

Report

Posted on by Phil3612

Hi,

I haven't done much with Power Automate yet so still learning. I have created a PowerApp that sends data to a SharePoint List, it is user data that has to be submitted daily by each user. What I would like to do is create a flow that checks that each user has submitted data Monday to Friday and then if not it sends an email to me with the users that haven't submitted data each day. I thought maybe it could check against an excel column of names or maybe another SharePoint List.

Is this even possible with a flow and if so how would be best to achieve this.

Any help would be appreciated.

Thanks in advance

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@Phil3612 You can use a Filter Array action to compare your Excel table data against a SP List.

To learn more about how to use the Filter Array action, please refer to this YT Tutorial: Are you using the Microsoft Power Automate Filter Array Action wrong?

In this video tutorial I’ll show you 3 practical ways to use the Filter Array action and how to use it properly.

1️⃣ Cross-Referencing Data

2️⃣ Filtering by Key

3️⃣ Substring Matching

Did you know that the Condition action has a limit of 10 conditions? Although it might look like the Filter Array action can only accept one condition—this is not true. By using the advanced mode you can enter multiple conditions into a Filter Array action with an expression.

IN THIS VIDEO:

✅ 3 Ways to Use the Filter Array Action

✅ How to use the Scope Action to Group Actions

✅ How to Check the Number of Items returned from a Filter Array Action

✅ How to Cross-Reference Data in Excel with a SharePoint List

✅ How the Filter Array Action Works

✅ How to Access the Dynamic Content from a Filter Array Action

✅ How to Filter Items by a Key

✅ How to Filter Items by Matching a Substring

✅ How to Use Multiple Conditions in a Filter Array Action

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
Phil3612 53 on at

Like (0)

Report

Thanks @creativeopinion I finally managed to get the result I need, which is a list of email addresses from a SharePoint person field that was not in another SharePoint list, i.e. it compares one to the other. I now need to send an email to everyone in the output of that filter array. I have tried this using Apply to each loop with compose etc. but keep getting failures. Is there something specific I need to do when getting data back from a person field. I don't need any fancy HTML in the email, just the standard text is fine.

Any ideas on how to do this would be appreciated

Was this reply helpful? Yes No