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 / Setting up a daily che...
Power Automate
Answered

Setting up a daily check on whether a file has been uploaded and if not, send an email

(0) ShareShare
ReportReport
Posted on by 17

Hey! 

 

Fairly new to power automate and while I've set up a couple of simple flows, struggling to get something working for what I want.

 

There's a "Send an email when a new item is created in Sharepoint" template, but I want it to do the opposite (kind of) where by it will check at a specific time of day (I'm fine setting up the recurrence trigger) and send an email if an item hasn't been created.

 

Basically we have a sharepoint folder which itself contains a number of subfolders for a range of different reports that need to be actioned and uploaded for evidence each day, so I want a notification to be sent if that upload hasn't taken place by a certain time.

 

The report subfolders will be split into other folders for the year/month so not sure if the flow can be applied at "report folder level" so it doesn't matter where the new file was added as long as one exists with an upload date of today.

Categories:
  • Verified answer
    jinivthakkar Profile Picture
    4,187 on at

    @Micromanic this is how I think can be done

     

    List - File count

    Columns - Title, Count

    Values - Files - (Any numeric value, add current count or 0 if starting from scratch. if you don't know exact count then use get file properties action it will give you file count)

     

    Flow

    - Recurring everyday as per your requirement

    - Use get files and select the library you want to check

    - Check the count of files in and then check the file count against list, if the count matches no file was added. If the value does not match then a new file was added and update the count in the list(so next day the file count is matched against the updated file count)

    jinivthakkar_0-1639032787861.png

    This will get file count in library, if this works for you, next in the flow get item(pass Id 1), get the count value.

    Add a condition to check both values and based on result send email, update count value in list.

     

    If this design works for you could also have different flows which will check count of files in different folders.

    --------------------------------------------------------------------------------

    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

  • Micromanic Profile Picture
    17 on at

    Legend! Yep that works perfectly thanks 🙂

  • Micromanic Profile Picture
    17 on at

    Actually, might still be stuck... I'm not sure how I add in the count value and update it each day.

     

    So I've got this and when I test the flow the Output is 71 without today's upload (so if the output was 72 then it's fine.) I know I need to change the condition since I don't want it to always be testing against 71 as that'll be superseded.

     

    Micromanic_0-1639445418821.png

     

  • Verified answer
    jinivthakkar Profile Picture
    4,187 on at

    @Micromanic create a list to store your count like this

    jinivthakkar_0-1639468614541.png

    Then in the flow, get the count and check it against file count 

    jinivthakkar_1-1639468707411.png

    jinivthakkar_2-1639468802635.png

    Hope this helps.

     

     

     

     

     

     

  • Micromanic Profile Picture
    17 on at

    @jinivthakkar  thanks a bunch! Still got a lot to learn but this has helped me connect a few of those missing dots for me. 

  • jinivthakkar Profile Picture
    4,187 on at

    @Micromanic welcome

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 231 Super User 2026 Season 2

#2
David_MA Profile Picture

David_MA 217 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 170

Last 30 days Overall leaderboard