#PowerApps #TimerControl
Have you ever needed to track how long it’s taking to complete a process in your Power App? Using the Timer Control you can do that, however, the output of that timer value is stored in an unfriendly format. In this video, I show how you can take that timer value and format it in hours, minutes and seconds format.

Here’s the formula to output the timer control into this format:

With(
{
seconds: RoundUp(Timer1.Value/1000,1)
},
With(
{
minutes: RoundDown(seconds / 60,0),
secondsRemaining: Mod(
seconds,
60
)
},
With(
{hours: RoundDown(minutes / 60,0)},
hours & ” hour(s) ” & minutes & ” minute(s) ” & secondsRemaining & ” second(s)”
)
)
)

5 Comments
  1. Andreas Appel 1 year ago

    Great video April. Just one question. The duration of the timer. What does it do? The 160k ms value. Seems like the text-string you are designing the label with, using the with function can spit out numbers greater than 160s. Other than that detail, very good sharing. =)

  2. I like your teaching style, including use-case for the apps helps a lot to understand easily . Great video as usual

  3. utoro princewill 1 year ago

    Great video! Have you had any experience with load management on this? i.e. If I have an average of 30 users on this app, and it is refreshing every minute, will this cause the app to break or slow down?

  4. Sunny LM 1 year ago

    Hi April, thanks the video, but I don't understand why devided by 1000? Can you please explain?

  5. Vincent delamarre 11 months ago

    Hi @April, Do you know how can apply minutes to a slider and change increments? Let me explain what i am facing (hopefully clearly). I have a slider, the slider influences 3 text input fields (1. time in sec / 2. time in decimal / 3. price per minute. For example 1. "15secs"/ 2. "0,25 mins" / 3. "0.01 $"). I want my slider range to be as follows : Range 15 secs – 10 mins. So basically 10 mins is the max of the slider. How can i make the slider incrementally increase of 15 sec per 15 sec, but also change my duration data to minutes (so on a 60 base, not a 100 base) ? Hope you see what i mean. Thanks for your answer.

Leave a reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

©2021 TDG - We Are Back Baby!

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending
or

Log in with your credentials

or    

Forgot your details?

or

Create Account