Desk Booking & Reservation Power Apps Template 07-14-2020 07:04 AM - last edited 08-06-2020 07:39 AM

[aprildunnam]

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

[ahhollan]

I am setting up the app as a car reservation tool.  I need to change the date selection screen to allow the user to select a date range.  How would the 'continue' button onselect formula change to allow this?  Thanks again for this app.

[bbsin]

Hi @aprildunnam 

I have no coding experience and can't understand the syntax if it's too complex.. 🙂 ..  I am using your template for the reservation and it works.  thank you so much.  Trying my very best to build the app I need.   Would like to ask is it possible to add check in and out columns in the same SP list to capture the data?

as show below I try to create a Main Screen that will 

1) Navigate to the dashboard for booking

2) Button for CheckIN - that should update the check in data in SP but the data is not pick up into the SP list (check in time and user name).  What am I missing?

Appreciated if you can advise me .  Thank you

[Andy355455]

Hello @aprildunnam thanks For this, the design is really slick. Could you please advise on how best to add a location filter, ie if the desks are at different locations . Any advice would be appreciated. Thanks. Andy

[stevec1]

Hi @Andy355455 and @aprildunnam - I am also trying to insert new screens to filter different building locations and possibly floors but cannot get the filter to work correctly - any suggestions or ideas gratefully accepted 🙂 

[ClaireAllen]

@aprildunnam 

I've looked at your Desk Reservation Demo, and would like to implement this
The link to Download the solution is for LoastandFound, is that correct?

Thank you

Claire

[sharonsumner]

The link is close but not this app - or its moved!! its here... PowerApps/Desk Reservation Template at master · aprildunnam/PowerApps · GitHub 🙂

Sharon

[ChadVKealey]

@aprildunnam , I'm looking to port this to use Dataverse for Teams rather than SharePoint (we have multiple departments that want to use it, and that seems to be a more practical way to deploy multiple instances). I have only used the MS-provided templates in Dataverse for Teams, not built anything myself, so I'm not sure if it's even possible to take an existing canvas app and connect it to Dataverse tables? Any advice or resources would be greatly appreciated.

[ChadVKealey]

@aprildunnam I've been working on converting this to use Dataverse for Teams and figured out most of it with one exception. The short version is that it seems none of the "number" column types available in Dataverse support a value greater than 100,000,000,000. The "CheckOutFromNumber" and "CheckOutToNumber" columns store the start and end dates/times as yyyyMMddhhmm, which results in values like 202,109,100,900, which is larger than 100,000,000,000. On my very first attempt (before I learned that I could transform the columns in Power Query), it created those columns as Text and the values stored properly, but as strings. Since the Items property in one of the galleries compares the CheckOutFromNumber value (as a number) to the current date/time in the same format, it was throwing a "type mismatch" because it can't compare a text string to a numeric value. 

I tried "Value(CheckOutFromNumber)", but that causes delegation warnings (and I'll be deploying this to a few departments where there could be thousands of entries to filter). 

My only other thought was to switch to a two-digit year (yyMMddhhmm), which will get the numbers down to an allowed range (with the drawback that this app would have issues in 979 years as we approach Y3k - but that will be someone else's problem I guess). 

I wanted to see if you had any other suggestions on how to do this while maintaining the 4-digit year. I've tried (I think) every number-type column in Dataverse and keep hitting the same wall.

[Gabriel_Sanchez]

outstanding app!

would be too difficult to add an additional filter for example for different floors in a building?

this is very nice for a small office, but a large office with many floors could  be difficult for the user to sort trough the desks

thanks!!!

[ChadVKealey]

Shouldn't be too difficult, but you need to account for it in a few places. First, in the Desks list, then add a control (e.g.: a drop-down on the "select desk" screen) where users select the desired floor and then adjust the filter for the available desks gallery to account for the selection.