Book a Room App - show capacity

[cwill83247]

hoping someone can help - I am a very new to PowerApps so if you can bear with me 🙂

I have used the Book a Room App Template

I want to be able to show capacity of the rooms, and filter on this capacity.

From what I understand I need a new list to hold the additional information about the room - which I have created in Sharepoint. I am struggling to understand how I get this information for Capacity to display in the results.

Using Below I can get the capacity data from my SharePoint List called RoomsMetaData

LookUp(RoomsMetaData,email2 = "testroom@company.com").Capacity

I though the syntax below would work: However complaining about incompatible datatypes

LookUp(RoomsMetaData,email2 = (AvailableRoomEmailName)).Capacity

Any help or advise would be awesome 

[cwill83247 · Accepted solution]

Update: Incase may help someone in community 

"RoomType: " & LookUp(RoomsMetaData,Title = ThisItem.Email).RoomType.Capacity

Within the Gallery its currently using AvailableRoomEmailName -- and comparison I was overthinking , just add a text label in your gallery with syntax as above  (if you have a sharepointlist with Title (this has email address) and then you have a field called capacity...

I am very new to PowerApps so probably a better way but thought worth sharing 🙂

[v-qiaqi-msft]

Hi @cwill83247，

That's greate.

Could you please mark your reply as an answer to help more users?

Thanks for your cooperation.