Skip to main content

Notifications

Power Automate - General Discussion
Answered

Get information about no-data entry

(0) ShareShare
ReportReport
Posted on by

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.

  • Verified answer
    Rhiassuring Profile Picture
    Rhiassuring 8,688 on at
    Re: Get information about no-data entry

    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard