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

(0) Share

Report

Posted on by lliu_western

289

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

eka24 20,925 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
lliu_western 289 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

lliu_western 289 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No