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

Filter a Gallery with Office365 User's Manager

Hi All,


Is it possible to filter a Gallery with Office365 User's Manager - Display Name?

I am trying to do this, but I am getting an error.


Error message: This rule creates circular reference between properties, which is not allowed. A property cannot reference itself or other properties affected by its value.

Resident Rockstar
Resident Rockstar

Hi @scorpion77 ,

Yes, Possible.

Please find the below solution for your problem.

Filter(Sourcename,Lower(ManagerName) = Lower(Office365Users.Manager(User().Email).DisplayName))


Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay

Super User
Super User

@scorpion77 sure you can use the with the User's manager, but you will have to be clearer as to what it is you want to filter. 

Frequent Visitor

@rubin_boer  & @VijayTailor 

Thanks for your responses.


I am trying to filter a gallery with the Manager Combo box as a filter to select the Manager.

When we select a Manager, gallery should show only selected manger reporting users data.


In the Gallery, I am getting user's manager name from the Office365.



Tried this formula with my SharePoint data source. It's not working in this scenario.

Filter(Sourcename , Lower(ManagerName) = Lower(Office365Users.Manager(User().Email).DisplayName))

Helpful resources

PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,803)