cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mgodby
Post Patron
Post Patron

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

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

Mgodby_1-1608088146936.png

 

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?

Mgodby_2-1608088159412.png

 

Thank you.

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

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.

2.JPG


1.JPG

Best Regards

Bof

 

View solution in original post

2 REPLIES 2
v-bofeng-msft
Community Support
Community Support

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.

2.JPG


1.JPG

Best Regards

Bof

 

v-bofeng-msft
Community Support
Community Support

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.

2.JPG


1.JPG

Best Regards

Bof

 

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

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.

<
Users online (2,570)