combobox show 2 columns

Like (0) Share

Report

Posted on 15 Jul 2022 13:08:17 by julijazas

820

In my model driven app i have custom page(canvas app) and a combobox.

I want to show 2 columns(combobox earlier had a possibility to choose a layout) but this possibility is now gone.

Is there a workaround?

Categories:

Microsoft Dataverse

All responses (5)

Answers (0)

Cloudyjudgement 2 on 29 Dec 2024 at 15:19:52

Like (0)

Report

combobox show 2 columns

I know this is an old post but it's the first result when you google this issue, so I'll post my solution for others who end up here...

On the items property of the modern combobox add a concatenated new column to the data source like this-

Items = AddColumns(myDataSource, newColumn, firstColumnName & " " & secondColumnName)

Then just click the Fields property in the properties pane to add the new column to the combobox. With this approach you'll still have access to the other fields in the original data source and be able to patch back if needed.
Drew Poggemann 9,278 Most Valuable Professional on 16 Jul 2022 at 11:59:12

Like (0)

Report

Re: combobox show 2 columns

Hi @jja,

Could you utilize a collection to store the two values separately and then the combined value and then when the combined value is chosen, set two fields on the form (hidden) set to the other two in that row of the collection? You could then patch these values back.
julijazas 820 on 16 Jul 2022 at 07:45:40

Like (0)

Report

Re: combobox show 2 columns

@dpoggemann
this is nice approach but how do i patch then data back? Lets say i have employee code and name. I concatenate code and name and show in combobox but in dataverse i want to patch back employee code which in my case is a lookup column inside the table i want to patch
ANB 7,075 Super User 2025 Season 1 on 16 Jul 2022 at 07:03:25

Like (0)

Report

Re: combobox show 2 columns

Hello @jja ,
Hope you are doing well.
There are 3 layouts available for combo box in canvas. PFB screenshot:
As you are using custom page for your model driven app. And yes, Combo Box is supported control in custom page which is called Modern control. Please check this article from Microsoft.

And I can see that there is no layout option for Combo Box in custom page for model driven app. So, as a workaround, I would suggest you to create a canvas component using the component library. This component can have only Combo Box from canvas app.(So that you can choose double layout). Then import this component to custom page of your model driven app. Please check this Microsoft article.

I Hope this helps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Thanks,
ANB
Drew Poggemann 9,278 Most Valuable Professional on 16 Jul 2022 at 02:16:26

Like (0)

Report

Re: combobox show 2 columns

Hi @jja ,

Is this still valid or are you saying this approach doesn't work anymore? https://powerusers.microsoft.com/t5/Building-Power-Apps/Help-with-Combobox-List-to-show-multiple-columns-from-source/td-p/839218

Community site session details

combobox show 2 columns

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

combobox show 2 columns

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates