cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lliu_western
Resolver II
Resolver II

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

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. 

2 ACCEPTED SOLUTIONS

Accepted Solutions
eka24
Super User
Super User

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.

View solution in original post

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. 

View solution in original post

5 REPLIES 5
eka24
Super User
Super User

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.

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. 

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.

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. 

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.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,821)