Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Book a room - display room capacity

Is there any way to display fields other than the roomname and e-mail adress of a room/resource in EOL/O365?

I'm looking for a way to show the capacity (and maybe other attributes) in the book a room app. I'm kinda confused if the "capacity" property is an Echange field or an Azure Active Directory feeld.

Not applicable


Of course it does....

I was being an idiot 😫 - the code i made just cross-references itself and gets the first item..................

Ok, so in the previous picture you highlighted in yellow boxes the names of the rooms, could you let me know the names of those boxes and any code inside?

Hi @Anonymous 


Once again many Thanks. and i appreciate your time and the interest you are taking in solving this issue

Here is the detail

1. Screen Name = RoomSelectScreen on its OnVisible property it loads the following code 


Set(CalendarFromSelectMeeting, false);
    Set(AvailableRoomsCounter, 1);
    UpdateContext({ShowLoading: true});
    Set(RoomsLeft, Blank());
    Set(DateTimeRoomChange, false);
        ClearCollect(AllRooms, Office365.GetRoomsInRoomList(RoomsListsGallery.Selected.Address).value)
    If(CountRows(AllRooms) > 20,
        Set(AllRoomsConnector, Concat(FirstN(AllRooms, 20), Address & ";")),
        Set(AllRoomsConnector, Concat(AllRooms, Address & ";"))

    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)); ClearCollect(Facilities, RoomDetails);

    UpdateContext({ShowLoading: false});
    Set(RoomsLeft, CountRows(AllRooms) - 20 * AvailableRoomsCounter)







2. in this Screen There is  Gallery called RoomsGallery on its Items Property it Loads a Collection AvailableRoomsNameEmail. the Bold room names which are appearing on the boxes are simply text coming as Text = ThisItem.Name

3. under this RoomsGallery the name of box is BorderRadius which is button in itself (see following image)

4. under the same RoomsGallery i insert a label and wants to fetch info from my collection.

5. My Collection name is Facilities based on sharepoint list and has RoomCapacity, RoomName, RoomLocation etc details








Not applicable


So if the facilities sharepoint contains the room details and the gallery is set up from AvailableRoomEmailName would this work:

First(Filter(Facilities, RoomName = Title2_1.Text)).RoomCapacity


Assuming the page name is stored in Title2_1.


Give this a shot and let me know if an error comes.

Hi @Anonymous 


It threw the same error of Invalid Argument. I found a new solution and need a little tweaking.

What is did is that I added a columns in AvailableRoomEmailName Collection. This new column is coming from my second Collection which is based on SharePoint list (Facilities). The following formula is working 100% fine but I need little tweaking to add more columns in this and have no idea how.

AddColumns(AvailableRoomEmailName, "Capacity", LookUp(Facilities, RoomName = AvailableRoomEmailName[@Name], RoomCapacity))


Columns in AvailableRoomEmailName = Name,Email,Capacity

Columns in Facilities= RoomName, RoomLocation,RoomCapacity,Others


I hope we have find the solution if more than one columns can be added to the above formula




Hi @Anonymous 


I found the Solution and added few more columns in it and these are working fine

At the Item Property of RoomGallery following formula is adding all columns in AvailableRoomEmailName and each peace of information is accessible with dot (.) and name of newly added columns


I appreciate your efforts and time all these discussions caused this thought and we found the solution


Best Regards




AddColumns(AvailableRoomEmailName, "Capacity", LookUp(Facilities, RoomName = AvailableRoomEmailName[@Name], RoomCapacity),"Location",LookUp(Facilities, RoomName = AvailableRoomEmailName[@Name], RoomLocation),"Others",LookUp(Facilities, RoomName = AvailableRoomEmailName[@Name], Others))
Not applicable



Hopefully the whole conversation helps others trying to display capacity 👌

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.


New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,981)