I have a flow that normally runs every day and extracts 24hrs of audit log file data. But sometimes problem occurs, this cause missing extracts. I would need the next flow run to pick up from where the previous successful run had stopped.
What I would like is, within the flow, to initiate a variable with the timestamp of the last successful time that same flow ran. Do you know if there is an easy way to do this ?
Hi @BdArbonneau,
The function to get last successful flow runtime and have a next flow run to pick up from the time is not supported in microsoft flow currently.
I afraid that there is no any way to achieve your needs in microsoft flow currently.
If you would like the function to be supported in microsoft flow, you could submit an idea to flow idea forum:
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
Best regards,
Alice
You could have the final action of your flow record utcnow() in someplace, such as in a SharePoint list, and have this only occur if the previous actions are successful. Then grab this value at the start of the next flow run. If the flow fails the recorded date will not update so a subsequent run would attempt to extract the same data as the previous run.
User | Count |
---|---|
24 | |
14 | |
13 | |
10 | |
9 |
User | Count |
---|---|
51 | |
29 | |
29 | |
24 | |
22 |