Answered

Autocomplete label when selecting data from dropdown list

(0) Share

Report

Posted on by Gerardoplass

The question is the following, I have an excel file with 3 columns: name, email, telephone, the name I place as a drop-down list, I want that when selecting a name it autocompletes in a label its mail and in another label its cell phone. please your support

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

Mitanshu 1,658 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Try this as the text property for your input box: DropDown1.Selected.Email
Gerardoplass 66 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, thank you very much for your answer, I only get the Result option 😞
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@GerardoPlass

This is because you are using the Distinct function in your combobox Items property.

What is the Items property?
Gerardoplass 66 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, this is my applied formula, the idea is that when selecting the name of the list, the email of that person is autocompleted in the label. The list of names is an excel table where there is a name column and an email column
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@GerardoPlass

So you have one of two choices!

Your formula on the Items is narrowing your entire table to just one column - the COORDINADOR column. So there will be no other columns to use for your .Selected record of the dropdown.

So, one choice is you can get rid of the narrowing and change your dropdown Items property formula to: TB_COORDINADORES

Then you can reference CB_Coordinador.Selected.EMAIL for your TextInput Default as mentioned before.

OR, you can change your Default on the TextInput to:

LookUp(TB_COORDINADORES, COORDINADOR = CB_Coordinador.Selected.COORDINADOR, EMAIL)

Either will work!
Gerardoplass 66 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much, it worked perfectly

Result