Skip to content

Display Office365 users in PowerApps Combobox and Default value.

April 15, 2022
  1. First,create a Office365Users data connection in PowerApps application.
  2. Add a datacard in powerapps and then add a combobox to the card.
  3. Select combobox and then go to Items property and then add below function to see the users email accounts(If you want to see the users’ names, then you need to select “DisplayName”) Sort(Upper(Office365Users.SearchUser({searchTerm:UserComboBox.SearchText}).Mail),Mail)
  4. To make the combobox searchable, go to combobox properties and then enable “Allow Searching” as shown in picture.
  5. To show the blank values when a new form loads or when you select the record from the gallery, and if there is no value in the datable, use the following code. If(IsBlank(ThisItem.UserEmail),Sort(Upper(Office365Users.SearchUser({searchTerm:Blank()}).Mail),Mail),Upper(Office365Users.SearchUser({searchTerm: Parent.Default}).Mail))
  6. To save the selected value to database when you submit the form, add below code to Datacard Update property. UserComboBox.Selected.Mail
  7. Default value on details page: add value in below format in DefaultSelectedItems property. Table({Value: HydroBrowseGallery.Selected.userName})

Advertisement

From → Power Apps

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: