Hi April, this app is fantastic, it fulfills maximum requirements, only couple of thing if possible to add it will be perfect 1. Add Dropbox with employees data from SharePoint list column. 2. If one employee assigned to one desk can not be booked for another desk if possible booked employee name should be red marked. 3. Today reservations view with desk details and assigned employee to that desk and exportable to pdf if possible. 4. Each reservation should have specific auto generated 6 digits number. I think it will be perfect if it will have these options. Its not must just a suggestion. Once again thanks for nice videos to share the knowledge. Have a good day.
HI April - this is a really useful app for me to implement, one thing i can get to work is if a desk is book between 9am and 10am for example - if some then puts in a range of 9:30 till 10:30 then the desk shows, but it should not because the checked out time is still within the 9-10 range
Excellent work. I turned this into a parking booking system at headquarters with a glass of wine, this clip and the template in a jiffy. :-) Keep it up!!
Thankyou so much for this April. I have customised your app to be used as a parking space reservation app at the office. We only have 3 spaces and it's always a fight to get access. I was using Office 365 and setting the spaces as resources but this app is much better. I fixed the initial errors by taking out the spaces from the column names and changing all instances of Desk with Parking Space. It works great. Just need to convince my colleagues to use it now. Thanks again.
This is awesome Paul and exactly the reason I decided to build and share these templates. Makes me so happy to hear you were able to take this and customize it to meet a different need!
Thanks for this! Went down well at work. I edited your nav using a rectangle below the icon for the current screen (think you change the default on each screens nav) and also put a label over the top of each button with a hover fill, makes the menu a lot easier 😊
Hi April, This is absolutely awesome! I was working to get something similar created and this came as a great help. Made my life easier :) Thanks and keep up the great work!
It doesn't have the interactive map component that you had asked about (just a static one for now). That's obviously a little more complex and time consuming but I do plan to build that out eventually and make a video on it. Thanks again for the suggestion!
There's definitely a lot of need for a template like this these days. It would be cool to make a follow-up video where we get a few of us who have made a similar app like this and show how we tackled it in different ways!
Hi April, Thank you for this amazing power app template . I am now using it, but I am having a slight issues with the DESK RESERVATION LIST where CHECK OUT FROM and CHECK OUT TO Date & time does not match from what was selected from the app. I am not sure how and where to correct the mismatch in time zone
Hi Angelo - I just released a new version of the template that solves these time issues. I showcase what's changed in this video and there's a link to download in the description: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-JgvQjQsJa80.html
Hi April, Thank you for this great video. I 'm a beginner and tried doing this but keep failing at the basics. I know its a bit too much to ask but any chance you can share a "dummies" version of how to build this app. Would really appreciate it. Thanks
Hi Geoff - thanks for the feedback. That's a valid point. Since I am providing these templates to download I wasn't focusing on showing how to build it soup to nuts but rather explain it at a high level and show some important features. It would be a very long video to go over how to create everything from scratch
This is awesome... I was trying to achieve something like this but share the information on how you're resetting the previous/current date bookings ex:09:00AM to 11:00 AM desk1 booked for next user the same desk1 will be available same day after 11:00 AM how to achieve this … Many thanks
Would this room booking solution be able to show you a conflict for a future reoccurring meeting? We recently started using Room Finder in my tenant, and a small snag we have found is that when setting up a meeting room, it will only show you a conflict on the start date, but there is no way of knowing if a conflict exists on any future dates until after the meeting has been setup/sent, and the room declines the series. Any thoughts on how to work around this?
I'm going to use this! Thank you! I did get some errors when running the provisioner Flow though. Was able to correct it by adding spaces in the "Reserved By", "Check Out From", and "Check Out To" columns. Also, after you book a desk it says "Your booked!". I changed it to "You're booked!". :)
Hi @Reno730, I got the same problem and spent hours to find the error, then I read your comment. Dummy, I had to read the comments first. By the way, thank you. @April, thank you so much for this application, very great job. But please correct this error in github file.
I had the same issue. Changed the names but still having a couple of problems. The Dashboard still shows an error (red X to the left of the "Upcoming Reservations" text). Says that The SortByColumns function has some problems and then down at the line "Check Out From", it says "The specified column 'Check Out From' does not exist. However, it clearly does. I also do not see my upcoming reservations.
Got it. I typed out the formula again and found out that the column name above "descending" is actually "Check_x0020_Out_x0020_From". I guess because of the spaces.
In the appointments screen, I want to show all bookings, with two tabs, today and next business day, (instead of Upcoming and previous). Can you show how i can filter by next business day, considering tomorrow could be saturday or sunday, and i don't want that day. Thanks in advance.
Brilliant stuff April. It ;looks like the Power Apps Studio desktop app has been deprecated. How can I test our your app (github) while using the web version of studio, please?
Hi April, It is possible to extend this to people, desk, items, cars etc. If I have multiple lists and if I want to include everything how would I do that? Would be good to have sections like DESK and under we have deskts, then expand car section and under that we have cars and so on? Is that possible.
Hi April :) This is great! I am creating an Asset reseervation app but they are requesting to have the asset reserved by dates in days (no times) , not just quantity. Do you have anything like this? One that would show how many assets are available and subtract the asset available quantity but only on those resevered days they select from date fields "To" and "From"? Any help would be amazing :)
Hi April, love your video trying to replicate what you are doing but running into a issue with the ThisItem formula, I get an error on it that doesn't return any data with the message : this formula uses scope, which is not presently supported for evaluation, any idea?
Hi, this was quite helpful in getting me started. I'm trying another approach which has multiple rooms which once selected shows available slots. My Time slots are coming from SharePoint list with increment of 30mins which is comparing the schedule list which stores all the bookings. How would I go about hiding the slots in case where the booking is for continuous multiple slots. Any suggestion?
me too ! but in my case, svg office map is a dynamic background with zooming, dragging and transitioning to the selected workplace on the map ( PCF component )
I would like to see how you can make a Mailbox/Locker reservation app where people can request a locker, get a key or code assigned to them and then reserve the locker over a subscribed time period (Day, Month, Year). If possible also have Each locker have its own attributes like location, size, and status.
Thank you for the app April, I was able to learn a lot! Question: what kind of control can I implement in the app or in the SharePoint list that would limit users booking the same desk with overlapping time range? As double booking may be an issue if two users accessed the app at the same time
Why you guys say it’s low or no code when you wrote do much complex filters? How do business know to write those,? Is it free cones by default that we just read and tweak? How to be aware of those,???
Hi April Dunnam, Thank you so much. it is really a great booking app. with your built file I have done some modification to my needs. I have some challenges when I am testing on different devices. in the mobile app and web, the date & time format are showing differently. In the web is showing mm/dd/yyyy and 12hr (AM/PM) time format. but in the Mobile app is showing dd/mm/yyyy and 24hr time format. how could I rectify that?
This will be great for me at work as we are now in need of something like this, Only problem is I am a complete novice to this, do you have any getting started videos/tutorials. Thanks
Hello April, great video of a great tool. Almost everything is working, except in the part DeskSelect. When I click on the "Information" icon I want to open a JPG file which was stored in de Sharepoint "Desks" library, Colum "Maplink". The code " Select(Parent);;UpdateContext({showMap:!showMap}) " won't open the JPG file in the app. Were is the hidden fault to get this solved?
Hi April, Firstly thank you very much for the app and it is really useful. However i would need your guidance on one error that the upcoming appointment does not show on the app its getting booked and i can see it populating on the SharePoint desk reservation site... It would be really helpful if you can guide me. Thank you.
Hey there - I just released a new version of the template that fixes some of these time issues. I showcase what's new in this video and there's a link to download in the description: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-JgvQjQsJa80.html
Hi, i Got i problem, I've downloaded the template but when i create the flow this doesnt create any list or page in my sharepoint page, I have already change the url page, What may I do to solve this? or in this case do I have to create each list?
Hi Cesar - So you import the Flow and you clicked to run it but it doesn't create the lists? Do you get any errors in the Flow after you run it? It might be easier to re-create the lists in this case
Thank you April. Great app, great template!. With some adjustments, I used it for parking space booking application in my company. Do you have any idea why images uploaded to the SharePoint gallery of the data source do not display? (their urls are stored in MapLink column). I checked some random urls from the internet and these worked correctly.
Hi Patryk, I figured this one out. If you have a map image saved in SharePoint, you can select the ellipses in the top left corner after opening the image and then select view original. You can then use that URL and it works as the Map Link.
fantastic video - I have inherited the app at a workplace. I have noticed that staff are able to double book a desk (maybe a change that the previous tech had done), anyways if I book desk say at 10am-4pm I can still book the same desk at 11am-5pm as it states its available. If I book before 10am the desk is not available - any suggestions would be great - thanks
Thanks April for this wonderful video as always. If you can let me know how exactly have you got floor image open aa popup on that little information icon inside gallery of select a desk screen
@@AprilDunnam Hi I am still have a problem, pictures for desks are uploaded but there still no preview. When I click on icon property there is a formula OnSelect Select(Parent);UpdateContext({showMap:!showMap}) but I can't find where it is connected? Is there a possibility that pictures too big?
Hi April, awesome app, my only comment, when selecting a desk say for an afternoon time slot, the desk is not available for a morning booking, is there a work around for this.
It's probably an issue with the field name in SharePoint not matching with the field name used in the "Items" property of the gallery on that screen. I would try adding or removing any spaces in the field names in that items property query and see if that fixes it
Rob Gibson 1 second ago Did you change the code and add spaces in the column names "ReservedBy", CheckOutFrom" and "CheckOutTo"? When you set up the Sharepoint lists the columns have spaces but in the code they don't. Then... you have to change the formula on the Dashboard and MyAppts pages. FirstN(SortByColumns(Filter('Desk Reservations','Reserved By'.Email = currentUser.Email && 'Check Out From' >= Today()),"Check_x0020_Out_x0020_From",Decending),2) The weird field name "Check_x0020_Out_x0020_From" appears to be because of the spaces in the column name. Not sure why the first reference to the column name is ok but not the second.
Hi April, I would like to add little dots into the calendar below each date showing with colours the occupancy on the respective day. E.g. More than half of the possible seats free = green dot, below half = organge dot and no free space = red dot. Can you show me how I can implement that into the app? That would be great.
@@AprilDunnam Hey April, thanks again for creating this video. I've successfully ran the flow to provision both custom lists and imported the canvas app. I ran the App Checker and encountered a Formula error. On the Dashboard screen, in the .gallMyReservationsPreview gallery, the Issue Details is stating "The specified column 'CheckOutFrom' does not exist". Would you have any idea what maybe causing this issue? Any feedback would be much appreciated. Thanks!
Whew, never-mind; I solved the issue on my side. It had to do with the syntax of "CheckOutFrom". The App Checker kept identifying that as a warning. I changed the syntax to reflect "Check_x0020_Out_x0020_Form" and that action cleared out the issue. Has this issue every happened to you?
Hi April I am using your desk booking powerapps. I want to add some more booking functionality in app like meeting room. When I create same screens as desks but calendar components not working well as expected. When I go to first for book desk and once successfully desk booked user get back to Dashboard screen and he can select room booking same as desk but when user go to calendar screen for room then whole screen goes to blank.
First and foremost, thank you very much for all these videos and trainings. Quick quesetion, do you have any templates for document editing and approval processes?
Thanks a lot April for this amazing and very useful app. Can you let me know how I can make the user to select only desk at a time? Probably have a radio button instead of checkboxes. I'm new to Powerapps, so appreciate any help.
Hi April love watching ur your tube. Can u also demo how to enable user to select a range of dates? How to select limit eg only allow book a room and grey out once fully booked with yr current app. Appreciated it. Thanks
@@AprilDunnam Thanks April, if i deploy the apps to teams and want users to use it. where should i give access - i assume read/write access in sharepoint so that they can add records and access floor maps also do i need to do anything on PowerApps so that the app will be visible in other users Teams . thanks again for your help
Hi April, I would like to say thank you as this desk booking helpful a lot. I am trying to show the locate of the desk like you do ,but when I putted a link with of the photo on DESK table on SharePoint is not working. What I need to consider on sharepoint or desk Booking to make it possible.
Hi April, this is awesome! Is there a way to extract this from your github for me to use as a template and then adjust as needed? How do I go about doing that?
Thanks April. Awesome app which I will use for our social distancing efforts when returning to the office in January. Is there a way to take an app and move it into a Teams environment so we could use dataverse?
Hey Rodney - yes there is actually! This is something that I plan to make a video on soon because I don't think there's any documentation out there for that right now. You should see an Import button in the Power Apps app in Teams that will let you import an app
Hi April, Great application! Just what we needed. I was wondering if there was a way to use, for instance, an If statement to make desks visible or not in a custom made map? You mentioned something like this in the comment to Keisha. If I try to use an if statement with the Filter code from the available desks gallery it tells me it isn't a Boolean value. Any possible way to make this "interactive" part of the map working?
Hi Felix, I think for an interactive map like that, you'd be better off creating that in PowerBI and embedding in the app. You could technically do it in Power Apps by adding in the image and overlaying it with rectangle objects as well.
Hi April. Thanks so much for putting up these videos, they are really useful! I was wondering is there a way of setting a start and end date of something. For example, if I wanted to create a booking system for the room would there be any way to hire it from say the 2nd Jan - 14th Jan?
Thanks for the easy explanation april. How do i format time to create an invite(v4) after my approval request is approved in sharepoint list.My date format in the list is mm dd yyyy hh:mm and it is producing error 400 to create an invite.
April, thank you for providing this amazing app! Question for you; how can I update the tab names and icons? Whenever I try to update the table the icons either disappear, or each tab ends up with the same name?
Hey Ben - those tabs are configured via a component. That components is added to each screen and there is an "Items" property that you set to define the names. I just did a video on components that might be helpful for this: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MQGqHwZdUes.html
@@AprilDunnam Thanks for coming back to me. I watched your video, but unfortunately I’m still having no luck. I’ve gone to Components > Tabs and located the Items property. If I update the Name(s), they change in the component view but don’t update on any screens where the Tabs component is used. If I change the Icon name in the Items property (within Components), all the icons disappear. Any ideas?
@@benadams109 You have to change it on each of the screens, not the component itself. Click on the screen with the component in it, select it there and change that items property
@@AprilDunnam thanks so much! I figured it out in the end. For some reason only changing the icon in the formula made everything disappear, but copying the whole formula out into Notepad, updating, before pasting back in worked perfectly 👌🏻
We've got different email domains in the user information in SharePoint vs. the login info for Office 365 (due to mergers, etc.) My name is even different (Greg vs. Gregory). Do you know of any other filtering options for the user to see only their own reservations?
I have a question. When you click on " my appointment" it goes to a different screen. I am trying this but what is the code for this in the component. It now says app.activescreen. but you would like to navigate ofcourse. So i now have this example item: {Name: "Reserveringen",Icon: Icon.Person, Page: App.ActiveScreen} (thanks for your help :)
Hi, April May I kindly ask why i cannot import the powerapps-sampples-main.zip folder i even tried to zip the deskreservation folder to upload but it always stops and this pops up (Something went wrong. Please try again later.)
Hi April, thanks very much for the video! I have downloaded your zip files from github. I have an issue with the calendar, the date of November 3 remains selected. Do you know why? Thanks for your help to fix the isue
Hello April, that app is amazing, but I'm experiencing an issue with overlap allowed reservations. Or better if I do it I see no problem but if another user make reservations looks like the filter to select the desks available do not works as expected and it allows to make double bookings. do you know why?
Hi I am getting a ThisItem.'Check Out To Text' = This formula uses scope, which is not presently supported for evaluation. Could this be a reason as to why I am unable to see the dashboard/my appt tabs? I made two other comments on the V3 video asking for help as well
I just downloaded the templated and set this template up. Our office so desperately need this. However, it is not showing some things like the Desk Selection list. How can I get help with this template
Hi April , I will add more credits to my predecessors :) Thank you! I've some litte issue. I am using Date Format in DD.MM.YYYY on my mobile so it show nothing for me. In web format which is US all seems be fine. Can you direct me which formulas need to be modified? Thank you again!
Thanks for the tutorial! can i ask where did u get the calendar in 8:31 or did you create it yourself. I found it but i can't find the way to connect the calendar to the sharepoint.
How do you do the filter with the not function when the sharepoint column is a multi-choice lookup? Is there a way to use your example but look at all of the values of the column? In my case, I am creating a calendar for meetings where the User can reserver multiple rooms across different offices. When I try to use your code I get an error "Power Apps can't convert this text to a table."
Hello April. i would like to limited calendar is that possible. the users must be see only one week. i dont want the users can not make booking for next weeks. thanks
Hey there - I just released a new version of the template that let's you do just that. I showcase in this video and there's a link to download in the description: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-JgvQjQsJa80.html
When I run the AppChecker, I get an error that says, "Navigate is not suggested in OnStart. Use the StartScreen property instead for better performance." I also get an error message when I play the app, and I'm wondering if it's related to that? The error message says "An unknown error occurred" with no further information. Other than that, the app works fine, except that I can't get the Manage Desks tab to appear, even though I listed my email in the DeskAdmins list. Any ideas on where to start looking?
Great app and design. just what I was looking for. I was wondering how to add the ability to disable a desk from being listed, perhaps due to maintenance or the desktop/hardware being repaired. I noticed you created an "Active" column in the Desks list. Wondering if this column was meant to determine if the desk is active or not. In PowerApps, would it be as simple as looking at this column for its value in the filter to determine whether a particular desk should be listed?
Hi Sergio - Yes, the "Active" column I have included in the template is intended to help you handle that scenario where you want to disable the option to select a desk. You can adjust the filter in the gallery and add where Active = "Active"
Hi Sergio - Wanted to let you know that I just uploaded a new video that walks through how to disable a desk: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GJe6l13rgF0.html
@@AprilDunnam the app will allow drivers to apply for parking with automated approval process. the app will also navigate them to the empty lots. Overall the app will have a list of parking duration for admin to know when the parking will expire. There will be no money involved in this app
Hello April, Thanks a lot for this. Please I am trying to develop a Gym Booking App on PowerApps wherein Users can select Date and Time slots. Such that there is a maximum number of users per slot eg: Thursday, 7 April 2022 10:00AM - Max number of users : 10. And users are unable to select such slots when the maximum number of users is reached. Thank you so much for all you do.
Hi April, Just wondering fi I could pick your brain on something. I need to build an equipment booking system in PowerApps for video production team for them to book things like camera kits, lighting kits, etc on specific dates. Just wondering if you know of any good tutorials or templates for this? I haven't found any yet, but figured you might have some ideas? Any assistance would be greatly appreciated. Thanks so much! DF
Hi April - I am 2 years late but soo happy I came across this as I have been tasked with a similar project. I have successfully imported the packages, but for some reason I am getting an error in the app that doesn't show which desks to choose from and an error message that says "uh oh, no openings found"...any clue on what this could possibly be? Thank you in advance!
Hey there - I would try installing the latest update to the app. It might fix the issue: github.com/aprildunnam/PowerApps/blob/master/DeskReservation/solution/DeskBooking2023.zip
Thanks for providing this! I've never touched Power Apps before, so a bit of struggle. I completed the "deployment" instructions per the GitHub page, but could use some guidance after that, if anyone has tips. 1. I added a desk to the Desks list in SP, but it doesn't show up in the app when attempting to make a booking ("Uh oh, no openings found!"). It was already connected to SP lists via the "Data" tab on the left. 2. Lots of small red "x" symbols. Seems related to the gallery groups? Not sure where to begin to fix this. Any help is appreciated!
Hey there - I just released a new version of the template that should fix a lot of bugs. I showcase what's new in this video and there's a link to download in the description: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-JgvQjQsJa80.html
Hi April this is so awesome thank you. However I am new to powerapps and wonder how I can view the desks created in the sharepoint list (desks) in the finished app? what do i input in the MapLinkI column?
Hi Luke - For the map link column you'll need to put in a hyperlink to an image file that shows the desk. If you need a spot to upload the image you could use OneDrive or a SharePoint document library and upload the image there then get a link to that and put it in the MapLink column
@@AprilDunnam that's brilliant thank you so much for the reply April! One more question if I may, is there a way for users to access the app if they do not have smart phones?
Amazing video,, thanks a lot for sharing the App template. I am going to use it :) thanks a lot . I have a question, How to set a notification when there is a desk status changed from booked to available?. so someone else can book it. Many thanks in advance. kind regards. Great work April
Hi Rana - You can use Power Automate for that. Since this template is using SharePoint as a data source - you can check for if that column has changed then send an email. I have a video that shows how to check for updates in Power Automate: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xvmi21KomK0.html
Hey April, awsome ideaa. Thanks for sharing the code. One question, any ideaa for securing it from users so the could not book more then 1 desk in the same day ?
Exactly, you can do a check in the data source just like you're saying using the IsBlank() to lookup to the data source. If it returns true then they don't have an existing reservation but if IsBlank() is false they do so don't allow them to book.