Unanswered

Datepicket with dropdown hour and minute

(0) Share

Report

Posted on by Community Power Pla...

I would like to be able to validate that on change, what is being entered in not in the past. I was able to do this on the datepicker, but its not looking at the hour and minutes. Any insight>?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Anonymous ,

To do this you'll need to combine the inputs for the datepicker and the dropdowns for hours and minutes:

DateAdd( DateAdd( DateValue.SelectedDate, HourValue.Selected.Value, TimeUnit.Hours ), MinuteValue.Selected.Value, TimeUnit.Minutes )<Now()

This formula will return true if the combined inputs are in the past. You may have to change the referenced to DateValue (DatePicker), HourValue (DropDown) and MinuteValue (DropDown) to match the actual names of the controls.

Was this reply helpful? Yes No
victorcp 2,350 Moderator on at

Like (0)

Report
Hi,

you can use the formula below to get the selected date and time

DateValue.SelectedDate + Time(Value(HourValue.Selected.Value), Value(MinuteValue.Selected.Value), 0)

then you can check if it is in the past or not

If( Now()>DateValue.SelectedDate + Time(Value(HourValue.Selected.Value), Value(MinuteValue.Selected.Value), 0), Notify("past"), Notify("future") )

any doubts let me know

Was this reply helpful? Yes No