ComboBox Issues

(0) Share

Report

Posted on by kriggo15

526

Issue:
I use a combobox as a person picker in a form and write the name and email to separate fields in my Azure SQL DB. This works perfectly.
I have another form that allows the editing of records based on a gallery selection. In that form, it populates the owner name but not the email field. It is as if the owner name isn't really selected in the combobox. So when I submit the form, it writes blanks back to the table for OwnerEmail.

OwnerName ComboBox properties:

Searching enabled, multiple selections off
Items: Office365Users.SearchUser({searchTerm:ComboBox2_13.SearchText})
DefaultSelectedItems: Filter(Office365Users.SearchUser({searchTerm:ThisItem.OwnerEmail}), Mail = ThisItem.OwnerEmail).DisplayName

OwnerName ComboBox properties:

Default: ComboBox2_13.Selected.Mail

Form Properties:

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@kriggo15

This is because you are trying to match a DisplayName (text) to a record (SearchUser). This will not actually match and give you a selected item.

Please consider changing your Formula to the following for DefaultSelectedItems:

Office365Users.UserProfile(ThisItem.OwnerEmail)

This will return a record that will correspond to a record from the items.

I hope this is helpful for you.

Was this reply helpful? Yes No