web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Check is timevalue is ...

Power Apps

Answered

Check is timevalue is between values

(1) Share

Report

Report

Posted on by PVosEska

329

Hi,

I have a SQL-Table with a DateTime Column.

I have a Form in powerapps that splits the column in Dates, hours and minutes

I want to automatically Update a textbox on hour and minute values.

for example:

If the time is between;

05:45 - 13:44 (Update with value A)
13:45 - 21:44 (Update with value B)
21:45 - 05:45 (Update with value C)

Any idea to do this?

Regards,

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (2)

Sort by

Verified answer

mdevaney 29,993 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
@PVosEska

Put this formula in the Text property of your label or text input.

With( {myTime: Time(drpdown_hour.Selected.Value, drpdown_minute.Selected.Value, 0)}, If( myTime > Time(5,45,0), "C", myTime <= Time(5,45,00) And myTime > Time(13,45,0), "A", myTime <= Time(13,45,00) And myTime > Time(21,45,0), "B", myTime <= Time(21,45,00), "C" ) )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@PVosEska

Try this related solution:

Compare two times
Verified answer

PVosEska 329 on at

Like
a
(0)

Report
Copy link

Link copied!
That was a great start @mdevaney ,

The only issue was the time from 00:00 to 05:45.
I changed the formula a little, and it works great now.

With( {myTime: Time(HourValue1.Selected.Value,MinuteValue1.Selected.Value, 0)}, If( myTime >= Time(00,00,0) And myTime < Time(5,45,00), "N", myTime >= Time(5,45,00) And myTime < Time(13,45,0), "O", myTime >= Time(13,45,00) And myTime < Time(21,45,0), "M", myTime >= Time(21,45,00), "N" ) )

Thanks for the very quick reply!

Join the conversation