Drop Down with a list of Employee's Name coming from Office D365 Users List

[lliu_western]

Hi Community,

I need a DropDown that contains a list of all office D365 Users and default of the dropdown set to the user that is using the PowerApps. 

I tried this function in the Item: Office365Users.SearchUser({searchTerm:""}).DisplayName but it doesn't work. I think it's because the search term is looking for blank value but I am not too sure how to get rid of that part and just return a list of names.

Please help, thank you. 

[eka24 · Accepted solution]

it strange it not working for you.

Office365Users.SearchUser({searchTerm:""}).DisplayName works, but if not try a collection

Create a collection:

ClearCollect(MyUsers,Office365Users.SearchUser({searchTerm:""}).DisplayName)

Then use the collection name in the Dropdown:

MyUsers

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[lliu_western]

Thank you. Still not showing any values. I am wondering if it could be something to do with my access of the office365 list. I will check on that. Thank you. 

[eka24]

Ok check and give the feedback

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[lliu_western · Accepted solution]

My original formula worked all the sudden. For some reasons, it wasn't loading the names. However, it is not showing every available names, only showing the names start with A. I am guessing it's because the list is too long. 

[eka24]

You can try it on a combobox instead of dropdown

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.