How to pull all SharePoint items that are overdue and match District with Excel File District to get Supervisor Name

(0) Share

Report

Posted on by SPS-DEV-22

516

I have a SharePoint list holds that holds district information.

I have an excel file that has the district information as a column (Title) and for each district there is a supervisor.

Excel file example:
Title Supervisor
1 Paul

2 Ray

3 Smith

4 Jimmy

5 Dan

SharePoint List has

in the district Column

What I want to do is match the SharePoint list District to Excel File District

and I then want to use that information in a Select Needed Column

I want to get the information sent as a daily email, with the various columns in the email. however, when I try to match the SharePoint list district to excel file district I create an apply to each.. I do not want the apply to each.

I just want each SharePoint list item be a row on my email.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @SPS-DEV-22

just to confirm one thing here, do you want each list item in sharepoint to be send via email ?

for capturing the email , or other data , are you trying to match with excel data ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
SPS-DEV-22 516 on at

Like (0)

Report

Yes the excel file has the supervisors
the SharePoint list has the district

Each morning the information would be sent via email

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @SPS-DEV-22

for confirming things, could you show how the excel data and sharepoint list looks like ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
SPS-DEV-22 516 on at

Like (0)

Report

I was able to solve, there was an issue with the Flow

Was this reply helpful? Yes No