Time between Start time and End time should be blocked.

(0) Share

Report

Posted on by DeepthiKasey

Hi,

i'm trying to block time between start time and end time.

I have 4 drop downs

start time - hours and minutes

end time - hours and minutes

Screenshot (43).png

User can book only 2 hours / slot

If one user blocks the time between 8am - 10am, others should not be allowed to book time slot btw 8-10

only can book before or after hours.

Screenshot (44).png

tried the above code by comparing date and time, but when user changes minutes value, it is allowing to book the slot. because it is not matching the exact value. >/ < are not working.

please help.

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

You could try just using numbers instead of datetime objects. For example instead of 8:15AM just use 815. This will give you numbers and make comparisions much easier in general. You could also convert all time to minutes from midnight. So again 8:15AM would be 8(60) + 15 = 495. I have done this for a few apps and it simplified the logic. You can always convert it back into a datetime object anyway.

Was this reply helpful? Yes No
DeepthiKasey 6 on at

Like
a
(0)

Report
Copy link

Link copied!

What exactly is the formula need to be use.. i have converted it into numbers like how you mentioned and saving those values to the backend with 2 text columns (TimeStart & TimeEnd) as well. Example,storing values like 815(TimeStart) & 1015(TimeEnd). Now i need to restrict values between these two column values.

If(!IsBlank(LookUp('Recreational activities','Court Text'=DataCardValue15.Text &&
Value(TimeStart) <Value(DataCardValue49.Text) , Value(TimeEnd)>Value(DataCardValue50.Text))),Notify("This slot is booked please book another slot"),SubmitForm(Form1));

Please help
Thank you

Was this reply helpful? Yes No
DeepthiKasey 6 on at

Like
a
(0)

Report
Copy link

Link copied!

What exactly is the formula need to be use.. i have converted it into numbers like how you mentioned and saving those values to the backend with 2 text columns (TimeStart & TimeEnd) as well. Example,storing values like 815(TimeStart) & 1015(TimeEnd). Now i need to restrict values between these two column values.

If(!IsBlank(LookUp('Recreational activities','Court Text'=DataCardValue15.Text &&
Value(TimeStart) <Value(DataCardValue49.Text) , Value(TimeEnd)>Value(DataCardValue50.Text))),Notify("This slot is booked please book another slot"),SubmitForm(Form1));

Please help
Thank you

Was this reply helpful? Yes No
mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

compValue is going to be the value you are checking:
If(compValue > Value(TimeStart) And compValue < Value(TimeEnd), **good number**, **bad number**)
replace the stuff in ** with the true and false statements you want to execute based on the output of the if statement.
Start time was 8:15AM -> converted this is 0815
End time was 4:30PM -> converted this is 1630
compValue is 12:45 -> converted this is 1245
If(1245>0815 And 1245<1630, "Time Is In Range", "Time Is Out of Range")

Was this reply helpful? Yes No
DeepthiKasey 6 on at

Like
a
(0)

Report
Copy link

Link copied!

One last question,
how you are calculating compvalue?
i have a slot 900 - 1100(9am - 11am)
i have taken startTime - 1030(10:30am) ,Endtime - 1230 (12:30pm)
calculated compvalue like ,(1030 +1230) /2 = 1130

if I use this values for the formula,
If(1130>900 And 1130<1100, "Time Is In Range", "Time Is Out of Range").

condition is not satisfying.. it is with the compvalue calculation. How to calculate that value?

Help me with this please

Was this reply helpful? Yes No