Dropdown Column how to get items but show those items with another title

(0) Share

Report

Posted on by Field

339

Hello,

I am creating dropdown column and i want to get items from a list. But i want to show a different Value while mantaining the same ID

I created the following code:

Table({Val: Filter(DATABASE; IdEstrutura = CodAgenciaID.Text).Email; Text: Filter(DATABASE; IdEstrutura = CodAgenciaID.Text).Name)

If I search for one or another, it works, if i do this code, it doesn't work and won't get anything. How do i get all the items in a list with different text based on another column

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

PowerAddict 7,316 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Are you trying to create a dropdown that displays emails instead of names or the other way round?

In either case, simply set the Item property of the dropdown (or combo box) to something like:

Filter(DATABASE; IdEstrutura = CodAgenciaID.Text)

And then in the Edit (or View or Display, I dont remember the name exactly but it's like the 2nd or 3rd property) Fields property to display either the email or name field of your DATABASE entity.

Let me know if this works.

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

Hardit Bhatia
https://thepoweraddict.com

Was this reply helpful? Yes No
Field 339 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

Crazy me... This was easier than i thought...
That was exactly that i wanted. Thank you so much!

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Glad I could help! Good luck with the rest of your app! Feel free to reach out in case of any questions!

Thanks,
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

Was this reply helpful? Yes No