Unanswered

Book A Room Template - Once room is booked, I need room to either be hidden or disabled for that time-slot.

(0) Share

Report

Posted on by jharville

Hello all,

I am using the Microsoft Book A Room template, and one thing I've noticed is that when I book a room, it doesn't remove the room from the Gallery. However, if I try to book the same room twice, it will send an email to my email address saying that the room was unable to be booked since it was previously booked.

My goal is to remove (or hide/disable) the room from the Gallery once it's booked ... so that other people don't get confused by seeing a room that has been booked in their Gallery displaying all rooms available.

This is the code that I have in the OnSelect of my 'Book' button:

So for example, if I select the 'Book' button next to the "Deck 1" room, I want the room to be deleted from the Gallery for that time-slot, or hidden/disabled in the Gallery for that time-slot.

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

BCLS776 8,994 Moderator on at

Like (0)

Report
Copy link

Link copied!
I had a quick look at this template, and assuming you haven't modified it much, it uses internal collections for most of the data handling. That gives you the option of re-generating the collections that query the Office 365 connector for available rooms. To do that you can put this series of ClearCollect functions in the OnSelect of a button named Refresh:
ClearCollect(AvailableRooms, Office365.FindMeetingTimes({RequiredAttendees: AllRoomsConnector, IsOrganizerOptional: true, Start: StartDateTimeUTC, End: EndDateTimeUTC, MeetingDuration: DateDiff(StartDateTime, EndDateTime, Minutes), MinimumAttendeePercentage: "1", ActivityDomain: "Unrestricted"})); ClearCollect(AvailableRoomsSorted, SortByColumns(First(AvailableRooms).MeetingTimeSuggestions, "Confidence", Descending)); ClearCollect(AvailableRoomsConcat,Concat(Filter(First(AvailableRoomsSorted).AttendeeAvailability, Availability = "Free"), Attendee.EmailAddress.Address, ",")); ClearCollect(AvailableRoomEmails, Split(First(AvailableRoomsConcat).Value, ",")); ClearCollect(AvailableRoomEmailName, AddColumns(RenameColumns(AvailableRoomEmails, "Result", "Email"), "Name", LookUp(AllRooms, Email = Address).Name));
Hope that helps!

Was this reply helpful? Yes No
jharville on at

Like (0)

Report
Copy link

Link copied!

@BCLS776

Thank you for providing the code, I really do appreciate it. I tried adding it to my app and it errored out, so I'll be working on it over the next few days to see if I can get it to be functional.

Was this reply helpful? Yes No
jharville on at

Like (0)

Report
Copy link

Link copied!

@BCLS776

I have a quick question. Would you know why this error is coming up? I've been messing around with it for awhile and still haven't been able to get rid of the error:

I tried removing the red-underlined portion of code, and it got rid of the errors, but the room didn't disappear from the Gallery once it was booked.

Thank you, I really appreciate your time and help.

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @jharville ,

Instead of using clearcollect would you try Collect only in the error code ?

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hmm, that still looks like a direct copy of the code that exists in the OnStart property of the app template, which is what we want to replicate. Could you check to make sure the statements just before the ClearCollect (I see an If(), but there may be others) are correctly terminated with a semicolon?

Was this reply helpful? Yes No
jharville on at

Like (0)

Report
Copy link

Link copied!

Hello and thank you for the response. Unfortunately, using Collect() as an alternative still brings the same error:

Was this reply helpful? Yes No
jharville on at

Like (0)

Report
Copy link

Link copied!

I checked and the If() statement was correctly terminated with a semi-colon:

I temporarily removed the If() statement for testing, and still saw the same error as well:

Is it possibly referencing a variable that hasn't been instantiated yet? Or maybe something else?

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @jharville ,
That clearly means there is issue with the variables you are passing. I would suggest to try commenting one field at a time to check which of the field value is creating the issue

Was this reply helpful? Yes No