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

Unanswered

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

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (2)

Verified answer

mdevaney 29,989 Moderator on at

Like (2)

Report
@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."

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like (0)

Report

@PVosEska

Try this related solution:

Compare two times

Was this reply helpful? Yes No
Verified answer

PVosEska 329 on at

Like (0)

Report
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!

Was this reply helpful? Yes No

Join the conversation