Rerunning Daily Flows that look back 24 hours

(0) Share

Report

Posted on by AS-03121158-0

I have a flow that runs every day at 5am. Due to the size of the sharepoint list it is linked to, I have an array created from the columns in the list I need, and then filter that array based on created date being between now and 5am on the previous day.

My problem is that if the flow fails on a Saturday monring, and I don't see it until Monday, how can I rerun it as at Saturday without having to edit the filter every time? Is there a better more dynamic way I can set up the flow?

this is my current Filter

@greaterOrEquals(item()?['CreatedDate'], addHours(startOfDay(addDays(utcNow(), -1)), 5)) )

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Ellis Karim 12,073 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @AS-03121158-0,

If you fix the conditions that caused the error then you should be able to resubmit the flow: https://youtu.be/LS-rZkk29r8

Ellis

Ellis Karim's Blog – IT doesn't have to be complicated!

Was this reply helpful? Yes No
AS-03121158-0 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @EKarim, If say it failed 3 days ago and I did not notice; when I rerun the failed flow, will it not only look at my items created in the last 24 hours, not in the 24 hours preceeding the failure?

Case: Flow runs 7 dec at 5am

Filter: All new items created between 6 Dec at 5am -> 7 dec at 5am (run time)

Flow fails

9 Dec failure is spotted. If I rerun on the 9th, will the filter not now contain all items created between now and 5am on the 8 Dec, therefore missing everything created between 6 Dec at 5am -> 8 Dec at 5am

Was this reply helpful? Yes No
Ellis Karim 12,073 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I think you are correct. The success of resubmitting the flows is going to depend on the conditions. The use of utcNow() in the flow will unfortunately take the current time, and not the time the flow was initially run and when it failed.

What is causing the error? Can we add some actions that can catch this error to prevent the flow from failing?

Other options:

(1) One option is to create a copy of the flow so you can run this flow manually. The flow should accept the value of addHours(startOfDay(addDays(utcNow(), -1)), 5) when the flow failed. But now you'll have two flows to maintain and keep in sync.

(2) Another option is to use child flows, but this is more complex, and all your flows need to be inside solutions. You can call your main flow from a scheduled flow or from a manual run flow (again, you'll need to get the value of addHours(startOfDay(addDays(utcNow(), -1)), 5) from the failed flow runtime).

Ellis

Was this reply helpful? Yes No