Unanswered

Filter People Picker by Department

(0) Share

Report

Posted on by AnnetteM

I have a screen that has a people picker field. I would like the user to start typing the name of a user and then user the Office365Users data to search for the entered text, but filter the results for folks in a specific department. For example, Julie may be a user in the company, but I would like the list to filter all the Julie's in a specific department.

I am currently using this logic on the people picker's Items property. Although it searches and shows the correct available matches, if I am changing a record, it will not assign the new value or if I am entering a new record, it will not write the selected value to the SharePoint list people column.

Filter(Office365Users.SearchUser({searchTerm:violation_IssuedBy.SearchText,top:3}),Department="department name here")

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-dezhili-msft Microsoft Employee on at

Like (1)

Report

Hi @AnnetteM ,
Do you want to update the SharePoint person column with data from Office365Users.SearchUser?
Their data structures are different, so you should override the update property.
Best Regards,
Dezhi

Was this reply helpful? Yes No
AnnetteM on at

Like (0)

Report

Thanks for the update. Your solution works! I do have a follow-up question, however. I show a save button on the form that is visible if the forms.unsaved value is true. The minute I made the items property of the choice field a filter of the Office365 users to list only folks in a department, the form.unsaved property changed to true -- making it appear like all of the records shown in the form are unsaved. Is there a way to get around this?

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Hi @AnnetteM ,
We really understand that you have more than one issue need to be solved today and we are surely happy to help you with those, but to better focus on the new problem and ensure the service quality, we would advise you to create another ticket on the issue. It can also help us to get the case better recorded and let Microsoft know what you have been through clearly. Thank you so much for your understanding.
Best Regards,
Dezhi

Was this reply helpful? Yes No