search

aprildunnam / PowerApps

Collection of Power Apps template apps, components and examples
Other
413 stars 226 forks source link

Double booking same desk #89

Open pherez opened 1 year ago

pherez commented 1 year ago

How to disable double booking and also how to pick multiple days

image

aprildunnam commented 1 year ago

That's odd I tested it a few times and couldn't get it to do a double booking for me. Can you provide more details on the steps you went through to get a double booking so I can try to reproduce?

pherez commented 1 year ago

The issue is that the desk once booked and taken up it does not disappear from the list, it still shows up as a available desk to be chosen.

Multiple date picking capability is also not available , it should be able to choose like two concurrent dates.

MikeBetts44 commented 1 year ago

You can double book it yourself but others can't so I think it's fine but not perfect. Probably a small tweak to sort this.

mqcarpenter commented 1 year ago

@pherez multi-date selection is a global variable. Concerning double booking, I thought I was experiencing this, but found that it was because I was booking as an admin. I removed my account from that list and it no longer showed unavailable vehicles in that time range. @MikeBetts44 this applied to myself and others. In other words, I could not double book for myself when I was no longer an admin.

MikeBetts44 commented 1 year ago

@pherez makes no difference at all I'm afraid. Browser's are a big issue. The issue is it's fine for some and not for others so difficult to address because if this. You can drill down the issues. See one of my replies to another query earlier.

adfrew commented 1 year ago

Hi, I have a similar issue. When adding a "New booking" if I select the date I want first then Desks available are filtered, but If I select a clear date (or leave it blank), then choose a desk I know is booked say tomorrow. I can go back to the date select tomorrow and book it out. I have done this for multiple people for all sorts of different timeframes conflicts. 1 person has it for the whole week, another a day, and another just 1 hour. All conflicting, but no warning to anyoner, all bookings seem to be confirmed and the data certainly gets written to Sharepoint.
I think the solution is some sort of Display logic control to check the selected desk, during that time already exists in Desk reservations list on the Confirm button to stop it even being selected. Of course, it would be good to notify users why they can't make a booking i.e. Desk is already booked during this time.
But I haven't figured out how to do all of the above yet.

MikeBetts44 commented 1 year ago

Hi, I have a similar issue. When adding a "New booking" if I select the date I want first then Desks available are filtered, but If I select a clear date (or leave it blank), then choose a desk I know is booked say tomorrow. I can go back to the date select tomorrow and book it out. I have done this for multiple people for all sorts of different timeframes conflicts. 1 person has it for the whole week, another a day, and another just 1 hour. All conflicting, but no warning to anyoner, all bookings seem to be confirmed and the data certainly gets written to Sharepoint. I think the solution is some sort of Display logic control to check the selected desk, during that time already exists in Desk reservations list on the Confirm button to stop it even being selected. Of course, it would be good to notify users why they can't make a booking i.e. Desk is already booked during this time. But I haven't figured out how to do all of the above yet.

@pherez, @aprildunnam - My app is heavily modified. I've separated it into 2. One app is for users. One app is for admin to manage the desks only. However I've sorted all the issues out and it would be easier to give you the file. I have added a form link to report desk issues and desk plan but you could simply delete those. Double booking is not an issue, however you have to ensure everyone is using UK browser. A lot of browsers are default US and this messes with the dates. However, to get round this I have created a power automate alert which sends a link to anyone that uses a US browser the first time they book with a YouTube video showing how to address. So it's a problem only once and self healing. I also have a PowerBi dashboard linked. Lastly, I've created another page to the app where you can check desks and people before you book.