Unanswered

save the sum of the duration of each action in my flow to excel

(0) Share

Report

Posted on by fabcanver

I want to get the total of the duration everytime my flow runs. As you can see in the attachment, i want to sum all the time taken for each action and save it in an excel file. Can anyone please help me on this? Downloading the run history does not really help me.

What i want to achieve is to get the duration it took for each series of runs.

sumof flows.png

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

RobElliott 10,391 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

@fabcanver as far as I'm aware there's no way to extract the duration of each action and save it to excel.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @fabcanver

If you use result(), you can get the start and end time of an action. Note that result will only return top level actions of a scope, apply to each or do until. I have a demo of result() in this video https://youtu.be/ou8bfkT2Dnc

If you had three actions in a scope like so:

You can then use a select to retrieve the start, end, name and difference for each action and then the first start and last end date in a compose to get the overall runtime.

Tom has a good article on ticks https://tomriha.com/how-to-calculate-difference-between-two-times-in-power-automate.

The outcome of the flow above, where the delay is set to 5 seconds is:

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts.

Was this reply helpful? Yes No
fabcanver 3 on at

Like (0)

Report
Copy link

Link copied!

Hi @DamoBird365 ,

Thank you for your prompt response and i think this is what I am looking for. I am really new to Power Automate and not very familiar with all the functions yet. Would you be able to share the expressions you have for each action or share the sample flow you have created above?

Thank you so much would really appreciate it.

Was this reply helpful? Yes No