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 / Send a Notification on...
Power Automate
Unanswered

Send a Notification only on first item created in 1 day

(0) ShareShare
ReportReport
Posted on by 54

Hi,

 

Let's say you have a SharePoint list, and a flow with a trigger of "when an item is created"

 

Is it possible to send an email notification only on the first flow run for 24 hours?

 

Categories:
  • Expiscornovus Profile Picture
    33,997 Most Valuable Professional on at

    Hi @noelflores,

     

    I would say this should be possible. You could add a Get Items action with a Filter Query which checks if Created is within the last 24 hours.

     

    After that in a condition you could check the length of the response of the Get Items. If this equals to 0 it should sent the email. Otherwise it can simply go to the If No section (without any email actions).

     

    If you want I could add an example for this approach?

  • Redders Profile Picture
    546 on at

    Hi @noelflores ,

     

    Following your "When item is created" trigger, add a "Get items" and use the filter query as @Expiscornovus advised. You would want to add in the time if you are looking to return anything within the last 24 hours. If it is anything for just today, then remove the time from the query. 

     

    Then as @Expiscornovus advised, you need to add a condition where you check the length of the Get items body value, if this is equal to 1, then you can trigger the email in the yes part of the condition. 

     

    What this will essentially do is to count the amount of records that exist within the timeframe that you filtered, if there is only 1 then this would be the first within that timeframe and will send an email. If there is more than 1 then it won't and won't trigger the email

     

    Redders_0-1662981631373.png

     

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
Mohsin Ali Profile Picture

Mohsin Ali 426

#2
11manish Profile Picture

11manish 345 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 308

Last 30 days Overall leaderboard