cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
scorpion77
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.

3 REPLIES 3
VijayTailor
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))

Thanks,

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

rubin_boer
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. 

hey there if you liked the post give it a thumbs up, and if it solved your question please accept it as a solution.
scorpion77
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.

Office365Users.ManagerV2(ThisItem.Email).displayName  

 

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

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (4,324)