Hello, I’m trying to use Microsoft 365 tools to create a system where users can book a car and receive approval from their superiors.
I've tried using Microsoft Bookings, but it won't allow reservations longer than a day, among other limitations. I’ve also tried using Outlook rooms and equipment, but I’m having difficulty finding a way to obtain additional information about the reservation, such as justification and destination. I’ve tried using Power Automate to send a Microsoft Forms link to the person who creates the reservation, but I can’t guarantee that the responses I receive will be linked to the event created because they might not respond immediately.
It is really important that the user can see a calendar with the availability of the vehicle. I know I can use Power Apps, but I've been trying to avoid that since it is a bit more complex.
Can I have suggestions of what to do?
Wondering if you ever got this to work? We want to do the same thing with our vehicles and seems bookings and forms are not robust enough.
Okay, I'm convinced haha. Thank you for the guide!
Exactly what I was about to say @RobElliott !
@despinxz I built a complex power app for my first app and learned a lot. You can do it. Just use Dr. Google.
Make a couple of SharePoint lists that the app will use as a source of info as well as send Power Automate flow info to.
You could have SharePoint lists like:
Format the SharePoint lists almost like if someone was going to basically book the reservation on the list by creating a new item with choice columns, and date range fields, approver name.
Then when you create the power app you will basically be making buttons for those columns in your sharepoint lists.
When the user hits Submit on the App, it will Patch the values to the list and then trigger the Approval flow.
Power Apps is basically designed to work with SharePoint. Tons of videos and how to.
What makes building the app easier is having the process mapped out with your sharepoint lists and approval flows first. Then you make the app to be an interface for the process you just made.
@despinxz Power Apps is the best solution. I built a desk booking system for my company back in 2019 combining Power Apps, Power Autoimate and SharePoint that was used for 4 years across 16 ofices until we were bought by another company. I did a similar one for booking lease cars. It is more complex but the end result is better.
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.