label based on time

(0) Share

Report

Posted on by rho1967

141

Hello everyone,

How is it best to show a label based on time.

The label must be displayed every day from 11:00 am to 2:00 pm

Best regards, Raymond van der Horst

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (3)

Sort by

Verified answer

BCLS776 8,994 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
In the Visible property of the label, paste this code:

If( DateDiff(Today(),Now(),Hours) >= 11 && DateDiff(Today(),Now(),Hours) < 14, true, false )

This will use the user's local time zone to determine 11am and 2pm.

Hope that helps,

Bryan

Was this reply helpful? Yes No
rho1967 141 on at

Like
a
(1)

Report
Copy link

Link copied!

Many Thanks BCLS776

Was this reply helpful? Yes No
rho1967 141 on at

Like
a
(0)

Report
Copy link

Link copied!

Only one question Bryan,

Is this also possible with minutes. example 16:15 until 17:02?

Regards,
Raymond

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@rho1967 wrote:

Only one question Bryan,

Is this also possible with minutes. example 16:15 until 17:02?

Regards,

Raymond

Yes, you can make this work for other times too. Keep in mind the DateDiff function returns only whole numbers, so it would make more sense to base a time such as 17:02 on Minutes instead of Hours in the calculation. 17:02 = 17x60+2 = 1022 minutes after midnight for the condition.

Was this reply helpful? Yes No
Verified answer

rho1967 141 on at

Like
a
(0)

Report
Copy link

Link copied!

Many Thanx,

It works when I refresh the page. But if it has to start itself then it won't be visible. What could this be?
Do I have to place the video on another page and then navigate to another page at a time?

Thank you very much

Raymond

Was this reply helpful? Yes No
Verified answer

BCLS776 8,994 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@rho1967 wrote:

Many Thanx,

It works when I refresh the page. But if it has to start itself then it won't be visible. What could this be?

Do I have to place the video on another page and then navigate to another page at a time?

Thank you very much

Raymond

The behavior you're seeing is because Today() and Now() do not continuously re-evaluate on their own - they need deliberate action through a behavior formula (one that starts with "On") to return a new value.

One way to deal with this is to create and set a variable using a timer:

Put varVisible in the Visible property you want to control

Insert a timer on the screen, set it to auto-start, repeat, and make it non-visible

Set the timer's duration to 60000 (one minute) and set its OnTimerEnd code to:

Set(varVisible, If( DateDiff(Today(),Now(),Hours) >= 11 && DateDiff(Today(),Now(),Hours) < 14, true, false ) )

Once per minute the app will re-evaluate the expression and toggle the variable & visibility of your control.

Was this reply helpful? Yes No