cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Delid4ve
Impactful Individual
Impactful Individual

Drop down display multiple columns from source table

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?
1 ACCEPTED SOLUTION

Accepted Solutions
mr-dang
Community Champion
Community Champion

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.

 

Microsoft Employee
@8bitclassroom

View solution in original post

5 REPLIES 5
mr-dang
Community Champion
Community Champion

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.

Microsoft Employee
@8bitclassroom
Delid4ve
Impactful Individual
Impactful Individual

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?
mr-dang
Community Champion
Community Champion

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.

 

Microsoft Employee
@8bitclassroom

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. 

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!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (3,731)