cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

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
Highlighted
mr-dang
Level 10

Re: Drop down display multiple columns from source table

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
4 REPLIES 4
mr-dang
Level 10

Re: Drop down display multiple columns from source table

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
Super User
Super User

Re: Drop down display multiple columns from source table

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?
Highlighted
mr-dang
Level 10

Re: Drop down display multiple columns from source table

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
CindyZ
Level: Powered On

Re: Drop down display multiple columns from source table

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. 

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

Users Online
Currently online: 4 members 4,667 guests
Please welcome our newest community members: