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 Automate
Answered

Daily Recurrence flow

(0) ShareShare
ReportReport
Posted on by 57

Hi all, (Hope I post this in the correct section).

 

I am fairly new to Power Automate/Flow and currently having a bit of an issue with a recurrence flow that I would like to create for a daily shift report. I originally had a flow running that when an item or file is modified an e-mail would be generated and distributed within the organisation, however after every update in the sharepoint page of a file/folder an e-mail would be generated. So I was thinking to change this to only once a day. But for some reason the recurrence seems not to be working. Would anyone be able to advise or has anyone another solution on how to prevent that an e-mail is generated with every update?

 

Thank you so much!

 

Best Regards,

Sebastiaan

 

Sebastiaan1_0-1606473691036.pngSebastiaan1_1-1606473751875.png

 

Categories:
I have the same question (0)
  • Expiscornovus Profile Picture
    33,868 Most Valuable Professional on at

    Hi @Sebastiaan1,

     

    I see you have two triggers in one flow. I would suggest you remove the when an item or a file is modified trigger action and add a different action for it instead.

     

    You could for instance use the Get files (properties only) action and use the filter query field to only retrieve file ids which are last modified today. Below is an example of such a configuration. I am using the following expression: 

    formatDateTime(utcNow(), 'yyyy-MM-ddT00:00:00Z')

     

    getfilespropertiesonly.png

     

    Hope this helps a bit?

  • Sebastiaan1 Profile Picture
    57 on at

    Hi Thank you very much!

     

    Just wondering how should I enter this? formatDateTime(utcNow(), 'yyyy-MM-ddT00:00:00Z')

    Is that just the empty recurrence or do I add this in an other way? 

     

  • Expiscornovus Profile Picture
    33,868 Most Valuable Professional on at

    Hi @Sebastiaan1,

     

    I don't think you need to change your schedule trigger action. I think you can just execute the following steps.

     

    1. Remove the When an item or file is modified trigger action

    2. Add a Get files (properties only) action

    3. Configure it to use your existing list

    4. Add the expression I shared earlier to the Filter Query field. You can add the expression in the filter query field via the add an expression button and copy pasting this expression:

    4. Add the expression I shared earlier to the Filter Query field. You can directly paste this in the Filter query field. Without having to use the add an expression button.

     

    Modified ge '@{formatDateTime(utcNow(), 'yyyy-MM-ddT00:00:00Z')}'

     

     

    addanexpression.png

     

    Hope this makes it a bit clearer what I was trying to propose. If you need any additional help just let us know.

     

    Update: Changed my mistake in step 4.

  • Sebastiaan1 Profile Picture
    57 on at

    Thank you! However I am getting the following error message: 

     

    The expression "2020-11-29T00:00:00Z" is not valid. Creating query failed.
    clientRequestId: c6b096eb-af31-46f2-9251-e0a468a0c108
    serviceRequestId: c6b096eb-af31-46f2-9251-e0a468a0c108

     

    Any idea what I do wrong?


  • Sebastiaan1 Profile Picture
    57 on at

    Sebastiaan1_3-1606683584466.png

     

  • Verified answer
    Expiscornovus Profile Picture
    33,868 Most Valuable Professional on at

    Hi @Sebastiaan1,

     

    Sorry my bad, I made a mistake in the steps. Step 4 should be:

     

    4. Add the expression I shared earlier to the Filter Query field. You can directly paste this in the Filter query field. Without having to use the add an expression button.

     

    Modified ge '@{formatDateTime(utcNow(), 'yyyy-MM-ddT00:00:00Z')}'

     

     

    The end result should also contain the Modified ge part to make it work.

     

     

  • Sebastiaan1 Profile Picture
    57 on at

    Hi all,
    The flow has been working smooth for a while until yesterday, for some reason the link to the file is not working correctly anymore, I haven't changed the flow.

     

    As you can see suddenly the %20 disappeared between Shift and Reports.

     

    New Situation:

     

    Sebastiaan1_0-1611781912417.png

     

    Old situation:

    Sebastiaan1_1-1611782031538.png

     

    Flow:

    Sebastiaan1_2-1611782133322.png

     

    Sebastiaan1_3-1611782203696.png

     

    Anyone any idea on what it can be?

    Thank you!

     

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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 711

#2
Vish WR Profile Picture

Vish WR 691

#3
Haque Profile Picture

Haque 525

Last 30 days Overall leaderboard