Displaying 2nd column data from dropdown in a textbox

(0) Share

Report

Posted on by Community Power Pla...

Hello, I am trying to build my first app (my 2nd day working in powerapps), so excuse me in advance.

I have successfully implemented a dropdown where the data is collected from 2 column sharepoint list.

For the sake of clarity;

Name Emailadress

The dropdown is distinct(table1,name), and also some sort().

I have text box to the right where I want to showcase the emailadress of the name selected.

I am thinking it is probably really easy, and I have looked up on Shane Young youtube and googled alot, and still cant find it. Also spent close to an hour figuring out concat formula, which I still dont fully understand.

Any advice is appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

There is no need for Distinct(). Simply sort your list by name. A dropdown contains the entire record even though only one field is shown in the window. The Emailadress can be obtained by reference to the dropdown as

Dropdown1.Selected.Emailadress

Distinct replaces the list with a single column table of unique values and renames the column Result.

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Anonymous ,

To populate the textbox with an Email address, based on the selection in your Drodown, you can use the LookUp() function:

LookUp(table1, Name = Dropdown.Selected.Result, EmailAddress)

In simple turns this performs a LookUp() in table1 where the Name is the same as the selected name in the Dropdown and then returns the EmailAddress for the first item it finds.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

That was indeed really simple. Thank you for your reply, I would probably be stuck for multiple hours.

I did have to use 'Name (Title)' = instead of name=, and I dont really know why. But I will probably understand that in the future.

Was this reply helpful? Yes No