Two time fields

(0) Share

Report

Posted on by mick3911

I have an update form that has a start time and an end time which the users enter the relevant times.

How can I ensure that the end time the user enters is not before the start time?

TIA

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hey!

You can use an if like this:

If( DatePickerStart.SelectedDate > DatePickerEnd.SelectedDate; CREATE FORM; NOTIFY ABOUT ERROR)

If you have a combobox with the hours just check this:

If( Value(DropdownStart.Selected.Value)> Value(DropdownEnd.Selected.Value); CREATE FORM; NOTIFY ABOUT ERROR)

If that gives you error, try without the Value():

If( DropdownStart.Selected.Value >DropdownEnd.Selected.Value; CREATE FORM; NOTIFY ABOUT ERROR)

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Take a label. Enter text like.
"End time should be greater than Start Time"
Set label's visible property:
StartTime>EndTime

Was this reply helpful? Yes No
mick3911 61 on at

Like
a
(0)

Report
Copy link

Link copied!
Reading the replies, I have realised that I haven’t explained myself correctly, so I will start again.

I have an update form that has a starthour time, a startminute time, a endhour time and a endminute time where the users enter the relevant times.

I have two labels (TimeStart and TimeEnd) where I have ‘joined’ the starthour & startminute and endhour & endminute together using the following respectively

Text(StartHour.Selected.Value&":"&StartMinute.Selected.Value,DateTimeFormat.LongDateTime24)
Text(EndHour.Selected.Value&":"&EndMinute.Selected.Value,DateTimeFormat.LongDateTime24)

How can I ensure that the end time the user enters is not the same or before the start time?

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Okay. So, i would do something like this:

1.Set those 2 dates in a var;

2. Check this:

If( varStartDate < varEndDate; Notifiy("Error"); SubmitForm())

You can also try a date diff but dont think it will work

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Was this reply helpful? Yes No
mick3911 61 on at

Like
a
(0)

Report
Copy link

Link copied!

But I am wanting to do this with time not date.

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

It is the same.....

1.Set those 2 times in a var;

2. Check this:
If( varStartTime < varEndTime; Notifiy("Error"); SubmitForm())

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Was this reply helpful? Yes No
mick3911 61 on at

Like
a
(0)

Report
Copy link

Link copied!

This is where I found out I am out of my league a bit with regards to variables.
How do I set those times in a var?

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Set( varStartTime, Text(StartHour.Selected.Value&":"&StartMinute.Selected.Value,DateTimeFormat.LongDateTime24))

If( Value(varStartTime) < Value(varEndTime); Notifiy("Error"); SubmitForm())

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Was this reply helpful? Yes No
mick3911 61 on at

Like
a
(0)

Report
Copy link

Link copied!

Under control field do I enter the Set var formula?

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

When you set the text, you set the var

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Was this reply helpful? Yes No