Answered

Filter Users on SharePoint List

(0) Share

Report

Posted on by MrLetts

I have a SharePoint List with a 'Person' column. When a person enters a new record they get an auto-complete/suggestion which is great. However, I want to filter the autocomplete suggestions to only show students.

I have done this in PowerApps on a separate application using Vertical Gallery and O365 Users, but ideally, I'd like to use the combo box that comes standard. With the Vertical Gallery I used:

Filter(
 Office365Users.SearchUser({ searchTerm: EmployeeTxt.Text, top: 500}),
 Department="Our School", StartsWith(JobTitle,"Student"))
)

How can I do the same with the combo box and ideally without the Office365 Users Data Connector?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

MrLetts 51 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm happy to use the O365 Users connector if needed

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @MrLetts ，

Please try:

ForAll( Filter(Office365Users.SearchUser({searchTerm: EmployeeTxt.Text,top: 500}),Department="Our School", StartsWith(JobTitle,"Student")) , { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Department: "", Claims: "i:0#.f|membership|" & Mail, DisplayName: DisplayName, Email: Mail, JobTitle: "", Picture: "" } )

Best Regards,

Bof

Was this reply helpful? Yes No
MrLetts 51 on at

Like
a
(0)

Report
Copy link

Link copied!

Perfect! Thanks so much!

Was this reply helpful? Yes No