04-28-2022 15:03 PM
I showcase my Desk Reservation system template built in Power Apps. This is a mobile based app that lets you book a desk and/or office space and keep track of your reservations.
This template could be used for many different scenarios like:
🖥Reserving Desks for Social Distancing
🏢Reserving Conference Room
🏫Booking appointments with a professor
💇 Salon appointments and Many more!
Download the solution here: https://github.com/aprildunnam/PowerApps/tree/master/Lost%20And%20Found
watch?v=zroxwXpVhHI
This is a great template app which I'm repurposing for vehicle reservations.
Does anyone know how to edit a reservation? Say if someone wanted to extend their vehicle reservation by a day, how would I go about doing that? The current filter won't show the vehicle because it's not available on all the selected dates, so it would need to ignore the current selected record or something?
Thanks in advance! 🙂
I love love love this simple yet elegant app. We are implementing it as we prepare to come back into the office. One question though: Is it possible to limit how far out someone can make reservations?
The calendar component has a "DaysAheadRestriction" property:
I believe the default value is 60 days, but you can change it to whatever value is needed.
Looks like I don't have that property but I can add it as custom. Do you have the details needed to add it as custom? And maybe an example of it's use.
Obviously, I didn't create the template, so I just reverse engineering here and might get something wrong. But, what I can see is that that property is a Number value. The only place I can find it referenced is in the DisplayMode property for the "btnDayValue" control in the "galCalendar" gallery (as shown below):
That formula is:
If( DateAdd( _firstDayInView, ThisItem.Value, Days ) < Today() || DateAdd( _firstDayInView, ThisItem.Value, Days ) > DateAdd( Today(), Calendar.DaysAheadRestriction, Days ), DisplayMode.Disabled, DisplayMode.Edit )
Also, if you don't have that, you might have an older version of the template. I used whatever the latest version was back in September of 2021 as the starting point for the app I've deployed. I say starting point because the departments that wanted to use it had some specific requirements that weren't met out of the box (like users being able to see one another's reservations, limiting specific desks to specific users [e.g.: only Managers can select Offices, staff can only book a cubicle/desk]).
Yes, I have the older version of the template. Thanks to you though I was able to add the property and modify the DisplayMode property. It's working like a charm! Thank you so much.
Hi, hoping someone can help. Excellent App but recently its allowing the desks to be double booked, because the filtering isn't being pickup from the SP list, anyone have any ideas:
Filter(
Desks,
Not(
Title in Filter(
'Desk Reservations',
'Check Out From' >= startTime && 'Check Out To' <= endTime || 'Check Out From' <= endTime && 'Check Out To' >= endTime
).DeskText
) && Active = 1
)
Should say as well that there is also a Delegation warning but I'm pretty sure that's always been there
I found that the logic for filtering the desks didn't work if users selected different time windows. I decided on one of two options. Either ignore the time or correct the logic. I also incorporated the use of the active field on the ignore time option. Here's the code for each:
//Does selected time overlap with existing reservations?
Filter(Desks,Not(Title in Filter('Desk Reservations',((CheckOutFrom <= startTime) && (CheckOutTo > startTime)) || ((CheckOutFrom < endTime) && (CheckOutTo >= endTime))).DeskText))
//Does selected date overlap with existing reservations and is desk active?
Filter(Desks,Not(Title in Filter('Desk Reservations', Text(CheckOutFrom,"mm-dd") = Text(startTime,"mm-dd")).DeskText) && Active<>0)
Thanks for providing context on the correct filter option. Any way around the delegation issue? Would you consider a flow that purges past reservations?