Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Missing IDs from records

Like (0) ShareShare
ReportReport
Posted on 12 Jan 2025 10:31:53 by 13
Hi, I want to build a flow which should run every weekday at 09:00AM. Requirement of flow is like-
I have excel file in sharepoint and it has 2 tables. 1st table name is "Tasks" and 2nd table is "Name" like below-
Tasks table:
 
 
Name table:
Flow first read excel file and pick all the records of previous date from "Tasks" table, if today is 12th Jan 2025 so i want all records of 11th Jan 2025 and so on. and i have thousands of records in my excel file and it will keep increasing day by day. 
Then flow will check "Name" table and if any 'User ID' is missing in "User Name" column of Tasks table then those 'User ID' and "Employee" records should be picked up and send an email in tabular form that these users records are missing in Tasks table.
 
I am a beginner in power automate so i need help to build flow for this task.
Thanks in advance

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

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,369 Most Valuable Professional

Leaderboard
Loading started