Answered

Update Form value with selected DisplayName in Combo box

(0) Share

Report

Posted on by 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

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
PatrickCheung 14 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Use:
User().Email

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

Was this reply helpful? Yes No
PatrickCheung 14 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

PatrickCheung 14 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No