web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Recognizing reservatio...
Power Apps
Unanswered

Recognizing reservations of the same item on the same date.

(0) ShareShare
ReportReport
Posted on by 12

Hello,

 

I have built a reservation app with Power Apps. Now I am trying to further improve it to not allow multiple reservations for the same item on the same day. Is there a way I can compare this with the event on the calendar and the date that is being considered for reservation? My set up right now is I have a dropdown for the selected date of the reservation, along with an in app calendar to view on a separate screen. The problem is multiple people can reserve the same thing on the same day. I am looking for a way to prevent that scenario because this app will actually be used.

 

I assume I will have to extract the subject from the event and compare it to the new subject of the new event and have a condition in which they can not match. I just do not know how to pull the data from the event on the calendar in Power Apps. 

 

Thanks

Categories:
  • SchwaiGUY Profile Picture
    14 on at

    Hi @KingKato 

     

    For me a LookUp Function can do the job to disabled the item already selected by another user...

     

    But can you show me a screenshot of you app to better visualize the problem ? 🤔

     

    When you talk about "in app calendar" is it with Outlook Calendar Connector ? It's a Component ?

  • KingKato Profile Picture
    12 on at

    Sure, no problem. The 2 pictures will be below. So the thing is with this we make the reservations using teams meetings. So the subject line would ideally be the vehicle name. Attendee would be who scheduled it. Screenshot.PNG

    So these are the 2 things I need to interact with eachother. Right now we have the idea of if a vehicle is already reserved for the day, a red error message would pop up under the vehicle section. Ideally I would like to have it take away the option for that choice of vehicle though. 

     

    Screenshot2.PNG

    As for the calendar, it is a connected calendar to an Outlook365 calendar for everyone. It is just the template calendar, with minor variations to show all of the details if a meeting is on that day, and to only show the specific calendar we use.

  • SchwaiGUY Profile Picture
    14 on at

    @KingKato 

    For me, you need to create a database in Sharepoint list for example and patch the data of the reservation (Date and Vehicles). 

     

    With this DB you can create a LookUp function in the DisplayMode or Visible property of each day in your calendar to Disabled the date where the vehicles is already reserved.

     

    There is an example of a LookUp function with 2 conditions in a DisplayMode property :

     

    If(IsBlank(LookUp("SharePoint List Name", Date=DatePicker.SelectedDate And Vehicles=Dropdown.Selected.Value,Date),DisplayMode.Edit,DisplayMode.Disabled)

     

    Did you use the Calendar Component created by April Dunam ? If it's this one I can download this tomorrow to find you a solution 🙂

     

    Let me know 😉

     

    Kind regards

  • KingKato Profile Picture
    12 on at

    Awesome, thank you for the input! That would be great, but I would feel bad if you had to go out of your way for all of that. I will mess around with that tomorrow and see if we should implement your suggestion for SharePoint! 

     

    As for the calendar component, I used whichever is set as a standard template in Power Apps under the new page selection. 

     

    I thought of a potentially easier solution in the mean time. Instead of searching for the date and vehicle to compare separately, I could just search the table on that day for subject (ie. Vehicle). If it contains that vehicle, then I could either disable the ability to choose it, or just give warning messages for each vehicle separately. Would you know how to do that?

     

    Given the date for instance like a random dd/mm/yyyy, just use that to view the event on that day and if it contains the vehicle it satisfies or un-satisfies a condition. This is what I have gathered so far, but do not know how to insert the selected date chosen in that first picture I posted above into this function. I am pretty sure I will find more bugs, but right now its issue is I only have 1 argument when it expects 2-3.

     

    If(
     Filter(
     Lookup(
     Office365Outlook.V4CalendarGetItems(
     Lookup(
     Office365Outlook.CalendarGetTablesV2().value,
     name = "Calendar",
     id 
     )
     ).value,
     "Vehicle" in subject,
     id
     )
    ) = "Vehicle", true)

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 393 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 278 Most Valuable Professional

Last 30 days Overall leaderboard