Daily Recurrence flow

[Sebastiaan1]

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

[Expiscornovus]

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')

Hope this helps a bit?

[Sebastiaan1]

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]

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')}'

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]

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]

[Expiscornovus · Accepted solution]

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]

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:

Old situation:

Flow:

Anyone any idea on what it can be?

Thank you!