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 / Get information about ...
Power Automate
Answered

Get information about no-data entry

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi.

I have a SharePoint list (namely - time_tracker) with columns like - Created By (person), Date (date), Hours (number), Work done (text).

I have say 40 people in my team.

I want to check, for each day, if all the team members have filled the time entry in the List's form.

How can I create a power automate flow that will check if there is no data for any member, so that I can later send an reminder to them to fill data?

I am open to adding any new column for any use for above case.

Categories:
I have the same question (0)
  • Verified answer
    Rhiassuring Profile Picture
    8,692 Moderator on at

    You'll want to run it once daily - so a recurrence.

     

    You'll want to have a dependable list of users to compare against. In another list, or, as an array.

     

    Step 1 will be to get that list of users. Say, Tom Hanks, Sally Field, Taylor Swift.

     

    Step 2 will be to create an "Apply to Each" and aim it at your array of names.

     

    Step 3 will be to use a "Get Items" with a Filter Query of Created By eq 'NAME' -- the 'NAME' would be the "Current Item" from Step 2.

     

    Step 4 .. a condition. If length(output) from Step 3 = 0, that means it's empty, and no time submission was received, so you'd want to send them a notification. If it's more than 0, then they've entered something.

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 86 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 55

#3
Ellis Karim Profile Picture

Ellis Karim 53 Super User 2026 Season 1

Last 30 days Overall leaderboard