User dropdown list

[Labraham36]

Hello community! I make a query: I need to create a drop-down list that allows me to choose the first and last name from all the users in the company. I have my app already linked to the office 365 database. How could I get this information in the drop-down menu?

Thanks!

[WarrenBelz]

Hi @Labraham36 ,

Try this

Filter(
    Office365Users.SearchUser(),
    DisplayName <> Blank()
).DisplayName

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Labraham36]

Thanks friend ! It worked ! But for some reason it only raises the first 100 users, can this limit be extended?

Thanks!

[WarrenBelz · Accepted solution]

Hi @Labraham36 ,

I don't use it a lot, so had not noticed that, This will get you 999

Filter(
   Office365Users.SearchUser(
      {
         searchTerm: "",
         top: 999
      }
   ),
   DisplayName <> Blank()
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Labraham36]

You are a genius Thank you so much for the help! It worked! I'm just bothering you for one more thing. In this company there are about 1500/2000 accounts, and when increasing the top it throws an error, Can more than 999 accounts be raised? Thanks!

[WarrenBelz]

Hi @Labraham36 ,

Already tried that unfortunately, though I have found a video from Shane Young that may offer some workarounds (also shortens my code a bit).

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.