Skip to main content

Notifications

Power Automate - General Discussion
Answered

System for car reservation

(0) ShareShare
ReportReport
Posted on by 8

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?

Categories:
  • AWMalicay Profile Picture
    AWMalicay 4 on at
    Re: System for car reservation

    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.

  • despinxz Profile Picture
    despinxz 8 on at
    Re: System for car reservation

    Okay, I'm convinced haha. Thank you for the guide!

  • Verified answer
    wskinnermctc Profile Picture
    wskinnermctc 6,512 on at
    Re: System for car reservation

    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:

    • Vehicle List - just the individual vehicles to be used like make and ID or whatever
    • Reservation Requests - these would the person submits from the App and runs the PA approvals
    • (maybe) Approved Reservations - this would be a list of approved reservations that could be used to plot the schedule of the vehicles.

    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.

  • RobElliott Profile Picture
    RobElliott 9,978 on at
    Re: System for car reservation

    @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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard