Unanswered

Populate a DropDown with Officeuser search based on job title

(0) Share

Report

Posted on by JC75

Is it possible to have the ITEMS of a dropdown be populated by running a filter on office365usersconnection, that would display Displayname(or email) of any user whose jobtitle is say "General Manager"?

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

v-micsh-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JC75,

Yes, there is a way to make it work.

Please follow the steps below:
1. Add the Office 365 User connection,

2. Add a Dropdown control, sepcify the formula below under the items property:

Filter(Office365Users.SearchUser(),JobTitle="General Manager").Mail

This would display an Email List of the people which have the JobTitle configured with "General Manager".

If you would like to customize the search part, you could change it as below, where TextInput1.text is used to input the JobTitle:

Filter(Office365Users.SearchUser(),JobTitle=TextInput1.Text).Mail

For more information about Office 365 User connection, please check:

Office 365 Users

Regards,

Michael
JC75 94 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi thanks for the help - however this doesnt seem to work -it accepts the syntax for the items field, but no values are populating in the dropdown? I've tried known jobtiltes for the value

Equally could this be modified once correctly working to be based on a startswith value - so "General Manager" would capture all jobtitles starting with that - which may be "General Manager this" "General Manager That"

Regards

James
JC75 94 on at

Like
a
(0)

Report
Copy link

Link copied!

Any additional help with this as I cant still get it to work
mlaurie 50 on at

Like
a
(0)

Report
Copy link

Link copied!

I too would love to see a resolution to this process.
EricVieth 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Instead of Filter, I used Search and had success. I believe its because Filter returns a table, where Search, returns the value in a table. So try Search(Microsoft365Users.SearchUser(),"General Manager","JobTitle")