Unanswered

Drop down display multiple columns from source table

(1) Share

Report

Posted on by Delid4ve

795

So my table is for equipment - make model serial etc etc.
Being able to see one field on its own in a drop down is useless.
I need to filter results from the equipment table based on a site ID (integer) then display the multiple fields per row.
In access this was easy but powerapps seems to only let you use 1 value. Even if they are concatenated that would be fine but I can't seem to get it to work.
Any ideas?

Categories:

Building Power Apps

I have the same question (1)

All responses (5)

Answers (1)

Brian Dang 3,976 on at

Like (0)

Report

Hi,
The Data Table control is now available for showing information in a table with multiple fields. You can find it in Insert > Data Table.

Was this reply helpful? Yes No
Delid4ve 795 on at

Like (0)

Report

A Table Is not what I want though. I want a drop down.

I have got the concatenate part working: (allowed values)
Concatenate('[Equipment]'.make,'[Equipment]'.model,'[Equipment]'.serial)

I can't seem to filter the data though, everything I try seems to break it.
Any ideas how to format this filter?

Was this reply helpful? Yes No
Verified answer

Brian Dang 3,976 on at

Like (12)

Report
I think I understand what you're asking now.

Normally you would set the Items property of the Dropdown menu to:

'[Equipment]'
But the dropdown menu can only show one column. To overcome this, I recommend that you add a helper column as you would in Excel. To do this, you will use the AddColumns() function:

AddColumns('[Equipment]',"helpercolumnname",Concatenate(model," ",serial))

Green: name of your database
Red: name of your helper column
Blue: what you want the helper column to show, reconfigure this to show whatever you want
Now that you've defined the helper column, you need to set the dropdown menu to show your helper column.

Let me know how it goes.

Was this reply helpful? Yes No
CindyZ on at

Like (0)

Report

Thanks ever so much! I finally understood and got Addcolumns to work for me. Both my concatenated fields show in my dropdown. The formula I've added to my Items field is as follows:

AddColumns(Regions,"Helpercolumn",Concatenate(gg0s," ",Title))

However, when I save the record, it saves the entire result of the AddColumns. I'd like it to write only the Title portion back to my list.

I'm using this function because my "gg0s" data is very wide, while the "Title" column is an abbreviated version or code that is meaningless in the dropdown without the explanation provided by the "gg0s" data.

Was this reply helpful? Yes No
William_Azevedo 98 on at

Like (0)

Report

Hi!

Using this example, what if my "serial" column is a lookup from another table? Is there a solution to show that column in the dropdown control?

Thank you in advance!

Was this reply helpful? Yes No