I have this desk reservation app and not sure how to restrict users to a single booking per day/single desk per day:
I basically need the code to check the sharepoint list for if there is a booking for the current day against the current user then no further bookings are allowed for that date. They will be allowed to make a booking for the future only then.
If(IsBlank("Desk Reservations", Date(selectedDate) && Employee = currentUser.Title),Notify("You can only have one reservation per day"), Navigate(DeskSelect)
Assuming Desk Reservations is the name of your list, try something more like:
LookUp('Desk Reservations', Date = selectedDate && Employee = currentUser.Title, true),
Notify("You can only have one reservation per day"),
Hope that helps,
_________________________________________________________________________________________ Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.