Unanswered

filter combobox based on user's department

(0) Share

Report

Posted on by ahhollan

576

I have an app with a people picker. Due to the number of records, I have created an excel table with all members of an Azure AD group. I want to filter the people picker so that it only displays people from the table with the same officelocation as the logged in user of the app. How would that formula be structured an where would I need it to go? items?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

Hello, @ahhollan, In the Excel table that you have created from the Azure AD Group, do you have the OfficeLocation, and the User Display Name or Emails?

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

ahhollan 576 on at

Like (0)

Report
Copy link

Link copied!

I actually figured it out.
First, I created a label that houses the current user's officelocation.
Office365Users.UserProfileV2(User().Email).officeLocation

Then I refer to that label in the following formula.
SortByColumns(Filter(colUsers,officeLocation=Label1.Text),"displayName",SortOrder.Ascending)

Was this reply helpful? Yes No