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.
Hi @scorpion77 ,
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
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))
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.