Is there a way to list out rooms filtered by Location?

[Mgodby]

Hello. I am listing out all the rooms for my organization. 

But what I want is to filter by Location. 
I set the Location in the admin center and I'm wondering if we can filter using this value in PowerApps?

Thank you.

[v-bofeng-msft]

Hi @Mgodby :

Please try this code:

Filter(
    AddColumns(
        Office365Outlook.GetRooms().value,
        "location",
        Office365Users.UserProfile(Address).OfficeLocation
    ),
    location="XXXXXXX"
)

For example:

I suppose to filter out the rooms on the 1st floor.

Best Regards

Bof

[v-bofeng-msft · Accepted solution]

Hi @Mgodby :

Please try this code:

Filter(
    AddColumns(
        Office365Outlook.GetRooms().value,
        "location",
        Office365Users.UserProfile(Address).OfficeLocation
    ),
    location="XXXXXXX"
)

For example:

I suppose to filter out the rooms on the 1st floor.

Best Regards

Bof