Answered

Flow time execution

(0) Share

Report

Posted on by fjexpo70

IS there any way to show the total time of the flow execution?
I would like to show in a final message the total time to run the flow.

Thx.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

Henrik_M 2,021 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
I made this, and it looks like it works. Can be shortened a lot, depending on how you want it presented. You really only need the 2x Get and the Subtract to get a result. Paste it into your PAD editor.

DateTime.GetCurrentDateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateAndTime CurrentDateTime=> DT_Start DateTime.GetCurrentDateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateAndTime CurrentDateTime=> DT_End DateTime.Add DateTime: DT_End TimeToAdd: 6564 TimeUnit: DateTime.TimeUnit.Seconds ResultedDate=> DT_End DateTime.Subtract FromDate: DT_End SubstractDate: DT_Start TimeUnit: DateTime.DifferenceTimeUnit.Hours TimeDifference=> TimeDifference Variables.TruncateNumber.GetIntegerPart Number: TimeDifference Result=> Hours Variables.TruncateNumber.GetDecimalPart Number: TimeDifference Result=> Remainder SET Minutes TO Remainder * 60 Variables.TruncateNumber.GetDecimalPart Number: Minutes Result=> Remainder Variables.TruncateNumber.GetIntegerPart Number: Minutes Result=> Minutes Variables.TruncateNumber.GetIntegerPart Number: Remainder * 60 Result=> Seconds Display.ShowMessageDialog.ShowMessage Message: $'''%Hours%h %Minutes%m %Seconds%s''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed

Was this reply helpful? Yes No
fjexpo70 22 on at

Like
a
(0)

Report
Copy link

Link copied!

@Henrik_M thank you for your time and solution. I understand the process but I do not know where or how to implement. I am using Power Automate Desktop.
Where to put the code?
Thanks.

Was this reply helpful? Yes No
Henrik_M 2,021 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Try the following:

Make a blank desktop flow and create a simple Display message action. Select it and press CTRL+C to copy. Paste your clipboard into Notepad. Your action is now text. It works the other way around, from text to action(s) in PAD.

Was this reply helpful? Yes No
fjexpo70 22 on at

Like
a
(0)

Report
Copy link

Link copied!

@Henrik_M it works perfectly. Go and back.
And the flow runs perfect with time execution calculations done exactly.
Thanks.

Was this reply helpful? Yes No
Crouching-SD 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, Henrik

I have some question about running time check.
Related to your solution.

1.Where should I put this code? Just end(below) of my code?
2.What about "2x Get and the Subtract to get a result" mean?
- 2x Get : Start time, End time?
- Subtract : subtract date?
3.What is add 6564 seconds mean?

Was this reply helpful? Yes No
Brett-Cleavely 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Can anybody help with this error??
I'm new here and also quite new to the world of Power automate.
Somewhat trying to run before I can walk but I give it a go.

the flow i created is to do the following
allow a user to fill in a MS form select a course title then enter their name and email

this triggers the flow to
create a certificate with their name on it the course title and date then automatically create a PDF certificate that gets emailed to them and also saves a copy of the same certificate onto SharePoint.
I copied the flow from a video on line. it seems to work to a point then gets stuck at step 4 and fails every time .
this i.e. the error message. The execution of template action 'Apply_to_each_4' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each_5')?['resourceData/responseId']' is of type 'Integer'. The result must be a valid array.

if anyone can help i would appreciate it try and keep it as simple as possible im just starting to learn the basics and technical jargon.
thanks Brett

Was this reply helpful? Yes No
Bhavadharani 50 on at

Like
a
(0)

Report
Copy link

Link copied!

How you are doing best @Bret could you please add attachments as well. It's easier to figure out

Was this reply helpful? Yes No