Answered

Need help in setting a limit for reservations

(0) Share

Report

Posted on by Patcanete23

Hello everyone,

I would like to seek your help. I am building a reservation app for an office space. How do I set a limit (ex. only 10 people per day)? Here are the variables, and connectors I used.

1. First the user needs to select a date in the calendar. The variable I used for this is selectedDate.

2. After selecting a date, they need to select a start time and an end time. The variables I used for the two are startTime and endTime.

3. Captured data will then be stored in a Sharepoint list with the following columns (CheckInTime, CheckOutTime, CheckInTimeText, CheckOutTimeText, CheckinTimeNumber, CheckOutTimeNumber).

I don't need the users to select a certain seat as it is a free-sitting environment. I just want to ensure that when they select their desired date and time, it does not accept their booking anymore if the count for that selected date and time is already beyond 10 users. I'm sorry if this question has been asked before, I tried to search the forum but none of them suits my needs. I hope someone here can help me how to get around this query.

Thank you very much. I have attached some screenshots for reference.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Patcanete23 ,

Generally, when Patching new entries into SP list, the App need to check the booked seats during the selected date and time by counting if there are more than 10 records in the list.

Firstly, you can generate another variable to save the selected date and time:

Set(startDateTime, DateTimeValue(Concatenate(selectedDate, " ", startTime))); Set(endDateTime, DateTimeValue(Concatenate(selectedDate, " ", endTime)))

Then OnSelect of submit button:

If( CountRows( Filter( SPlist, !(startDateTime >= CheckOutTime || endDateTime <= CheckInTime) ) ) < 10, Patch( SPlist, Defaults(SPlist), {...} ), Notify( "No Seats availabel in selected duration", NotificationType: Error ) )

Hope this helps.

Best regards,
Patcanete23 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you Jeffer Ni. I will try the above solution and update you. Thanks again.
Patcanete23 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately, it did restrict my booking, I was able to book more than 10 bookings for a specific date and time.
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Patcanete23 ,

I don't understand. Isn't that exactly what you're looking for?