Answered

Replica SharePoint Countdown Timer

(0) Share

Report

Posted on by ChadRobbins

In short:

I need a countdown timer to a specific day (Thursday) at a specific time (9 am) that recurs weekly and resets the value when it ends. It should look like the Countdown Timer web part in SharePoint, so it should display days, hours, minutes, and seconds (with a zero in front of each when appropriate).

Additional information:

Using a simple countdown feature (in conjunction with a Timer control) doesn't seem to work because the number of milliseconds in a week (604800000) seems to be outside the scope/maximum of either the timer control or the Text function. And as a result, the output defaults to "01:23:59:59", which makes it seem like the max is 2 days (which can't be true). Here is what I used in the Text property of Timer1:

Text(Time(0, 0, (Timer1.Duration-Timer1.Value)/1000), "dd:hh:mm:ss")

Also, it doesn't seem like the countdown is stored/saved between refreshing the app. So, this all led me to use the DateDiff() function which wouldn't need to store a countdown value; it would just subtract Now() from the target date (Thursday at 9 am). But I couldn't figure out how to turn the target date into a variable that could arithmetically play with Now().

Spent a lot of time looking into this to no avail. Thanks everyone!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

ChadRobbins 56 on at

Like (0)

Report
Copy link

Link copied!

Interesting, this solution doesn't seem to exist?

Was this reply helpful? Yes No
Verified answer

ChadRobbins 56 on at

Like (0)

Report
Copy link

Link copied!

App.OnStart
Set(viWeekDay, 5);
Set(vsNow, Now());
Set(viDelta, viWeekDay - Weekday(vsNow));
If(viDelta < 1,Set(viDelta, viDelta + 7););
Set(viTargetDay,DateAdd(DateValue(DateAdd(vsNow,viDelta,TimeUnit.Days)),9,TimeUnit.Hours));

Timer_DaysHoursMinutes.OnTimerStart
If( Now() > viTargetDay,Set(viTargetDay, DateAdd(viTargetDay,7,TimeUnit.Days)));
Set(viDeltaMinutes, Max(DateDiff(Now(),viTargetDay,TimeUnit.Minutes),0));
Set(viDeltaHours, Max(RoundDown(viDeltaMinutes/60,0),0));
Set(viDeltaDays, Max(RoundDown(viDeltaHours/24,0),0));
Set(viDeltaMinutes, viDeltaMinutes - (viDeltaHours * 60));
Set(viDeltaHours, viDeltaHours - (viDeltaDays * 24));

I experimented with a few different options on how best to play with the seconds, but I think the easiest I found was to create a separate timer that just counts to 60 seconds.

All credit goes to a colleague, thanks David.

Was this reply helpful? Yes No