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"?
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:
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:
For more information about Office 365 User connection, please check:
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"
Check out these cool Power Apps & vote on your favorite!
Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!