Update Form value with selected DisplayName in Combo box

[PatrickCheung]

I have created an EditForm with a Combo box using Office365users to get the DisplayName successfully. The intention is to update the email address of the selected DisplayName into another Form field (Text) named "Approver's email". I search through many discussion & try different method but no luck to get the email address resolved in the combo box and store it into the text field in the form .

The DisplayName can be selected through "Office365Users.SearchUser({searchTerm:ComboBox4.SearchText})" in ITEMS in the Combo box (Single value), but the missing information is how to get the email address of the selected item... And how to update another Text field (DataCardValue ?).

Thanks !

Patrick 

[eka24]

On the second form that you want display the name, put this in the default of DataCardValue:
OldFormName.LastSubmit.namecolumn
NOTE: editformName is the editform, namecolumn is the column name on the editform which holds datacardvalue for the Displayname

If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

[PatrickCheung]

Hi Eka,

Seems getting the DisplayName in the DataCardValue , Default with "ComboBox4.Selected.DisplayName".  Next question is how to get the email address that representing by the DisplayName. 

Thanks !

Patrick

[eka24]

Use:

User().Email

If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

[PatrickCheung]

Hi Eka,

The User().Email is getting the current user which is myself using the Apps, but not the email address of the Combo box.  And cannot use something like User(ComboBox4.Selected.DisplayName).Email

Thanks !

Patrick

[PatrickCheung · Accepted solution]

Oops ! ... Problem is solved by setting the Searchfield of Combo box to "Mail". Thanks !