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

4 REPLIES 4
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

View solution in original post

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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (46,584)