cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate IV
Advocate IV

Populate a DropDown with Officeuser search based on job title

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"?

 

 

 

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Populate a DropDown with Officeuser search based on job title

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate IV
Advocate IV

Re: Populate a DropDown with Officeuser search based on job title

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

Highlighted
Advocate IV
Advocate IV

Re: Populate a DropDown with Officeuser search based on job title

Any additional help with this as I cant still get it to work

Highlighted
Helper I
Helper I

Re: Populate a DropDown with Officeuser search based on job title

I too would love to see a resolution to this process. 

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (6,990)