web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Trigger email only onc...
Power Automate
Unanswered

Trigger email only once at the end of the day after modification in the sharepoint list

(0) ShareShare
ReportReport
Posted on by

Hi All,

 

I have an automated workflow built in power automate (Snippet below) for which if someone can please suggest how do I schedule to trigger the email at the end of the day only once despite having multiple modifications in the sharepoint list. 

PowerAutoU2_0-1696508878937.png


PowerAutoU2_1-1696509101107.png

 

 

Categories:
I have the same question (0)
  • Michael E. Gernaey Profile Picture
    53,351 Super User 2025 Season 2 on at

    Hi @PowerAutoU2 

     

    Based on the ask I am not sure exactly what you want.

     

    If you want to trigger a single email at the end of the day then use a Reoccurring Schedule and set it for 1 time a day and set it to 11:59:00 at night.


    Cheers
    If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

     

  • Community Power Platform Member Profile Picture
    on at

    Action named "When an item or a file is modified" comes under automated flow. When I create entirely new flow using scheduled flow template, after Recurrence action, I don't find action named "When an item or a file is modified". Please see the snippet below:

    PowerAutoU2_2-1696521986319.png

     



    While I try to manually create a flow using instant flow I don't find Recurrence action as shown on the below snippet:

    PowerAutoU2_0-1696521689514.png




  • Michael E. Gernaey Profile Picture
    53,351 Super User 2025 Season 2 on at

    Hi @PowerAutoU2 

     

    You wont because you asked to run it 1 time a day, you cannot run it 1 time a day AND combine that with the trigger of when a file is modified.

     

    You have to explain better what you are trying to do, because what I gave is how you do it one time a day, if you want it to be triggered, then its triggered, if you want to limit how many times something happens you use a reoccurring flow, not a trigger.


    Cheers
    If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

     

  • Community Power Platform Member Profile Picture
    on at

    Currently, the flow that I have built picks last version of the modified item and a mail is triggered. However, in case of a manual error it gets problem on my end when the mail considers last version and triggers an email. So I am trying to add an action like Recurrence or any other function that will send the mail only once at the end of the day (Eg 7:00 PM). Can I copy my built flow on the recurrence action or is there any way to fix this issue?

  • Michael E. Gernaey Profile Picture
    53,351 Super User 2025 Season 2 on at

    Hi @PowerAutoU2 

     

    Anytime your flow is triggered, it is the latest modified, so not really understanding why you have a check on the properties?

     

    But lets discuss what you want. 

     

    Clarification Question: At the end of the day, you would like the latest modified version, of any file that was changed on THAT day to be processed and then email some details to someone?

     

    If that is the case, then you still have to use a reoccurring. But you would need to do something like this.

    1. Use a reoccurring trigger

    2. Then you need to do a Get Files (properties) (action) to Loop through all the files in the folder you define

    3. In the loop, for each file call the Get File Properties

    4. Add a condition to check if the modified date is equal to your Today()

    --I have no idea what your timezone settings are etc so I cannot tell you exactly how to write your compare

    5. if it matches today. THEN in the If Yes (condition section) put all your current code. You will need to update any actions that rely on the content, to point to the Get Files (properties)  Apply to each Item to get the file pointer for your Get File Content in your current flow actions, versus the Trigger

     

    Now you will only send 1 email a day and you will have the latest for the day.

     

    NOTE: depending on what time you run this at night, it would be possible for the Day to move to the next day, so you may want to add a Compose at the top that greats the current Date so that you can use that to compare against the last modified of the file properties, versus using utcNo() or whatever. I hope that makes sense.


    Cheers
    If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

  • Community Power Platform Member Profile Picture
    on at

    The steps that you have mentioned for a reoccurring trigger doesn't include an action of "When an item or a file is modified". So, this wouldn't send an email if I modify any line item in the sharepoint. Also, "When an item or a file is modified" cannot be added as an action under reoccurring trigger. Please share a solution if you have an answer to this.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard