cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AVTS
Helper V
Helper V

Canvas App - Dropdown with multiple field

How to display multiple field information in dropdown.

 

Exisiting dropdown view is

Formula in items : If(IsBlank(TextInput4.Text),MaterialMasters,Search(MaterialMasters,TextInput4.Text,"crf99_fullcases","crf99_mm","crf99_singlecases","crf99_materialdesc"))

AVTS_0-1620585103298.png

 

Expected in dropdown.

82722500|Mleon

Table follows

 

AVTS_1-1620585223935.png

 

I am not comfortable with combobox. I need to try with dropbox only.

2 REPLIES 2
TheRobRush
Power Participant
Power Participant

Someone else, if I am incorrect, feel free to correct me. I am pretty sure the dropdown control is limited to the columns of the source as a display. The VALUE variable on the control is what determines the displayed list, and that to my knowledge cannot be customized, only chosen form a predetermined drop down list that generates based on the source.

 

 

You could concat/concatenate the source data every time on change to store a second version of itself in a collection and then have the drop down list reference the alternate version instead. After the user selects something another code would then have to split the result and use that to search for appropriate record with a filter of original data source.

_____________________________________________________________________________________
Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
This helps others find solutions to future issues!
Drrickryp
Super User II
Super User II

@AVTS 

Although a dropdown control only shows one field in its window, all the fields in the record chosen can be accessed. You can show them in labels referencing the dropdown with a text property Dropdown1.Selected.yourfieldname to show other fields selected in the record.  You could even put a concatenated tooltip on the dropdown if you didn't want to use real estate on your screen. 

 

Self.Selected.Field1&", "&Self.Selected.Field2&", "&Self(Selected.Field3

 

 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (2,981)