ComboBox Issues

[kriggo15]

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:

[RandyHayes · Accepted solution]

@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.