Concatenate dropdown Value

(1) Share

Report

Posted on by Danny_Dicaprio

Hi Everyone,

I have two columns in my Dataverse table, ControlID and Control Description

In the dropdown I want to show both of these values with a separation of '-'

I tried the following in the items Property Its not working

Filter(Controls, ControlID & " - " & ControlDescription)

Could anyone please help with these

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Sort by

anandm08 1,936 Super User 2024 Season 2 on at

Like (2)

Report
Copy link

Link copied!
hi @Danny_Dicaprio ,
You can create a collection in the OnVisible property of the screen or in the OnStart property of the app. For example, in the OnVisible property of the screen:

ClearCollect( CombinedControls, AddColumns( Controls, "DisplayValue", ControlID & " - " & ControlDescription ) )

This formula creates a new collection called CombinedControls, which adds a new column called DisplayValue to the Controls table, combining ControlID and Control Description with a hyphen.
Set the Items property of the dropdown to the new collection:

CombinedControls

Was this reply helpful? Yes No
Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

To achieve this you would need to create a collection to create this column. However you can also create it with a Calculated Column in Dataverse and just use this column instead.
This way you could use every column of the tabele with DropDown.Selected.ColumnName

the other way you would need to find a way to LookUp to Dataverse for everithyng.

Let me know which way you want to use.

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (1)

Report
Copy link

Link copied!

Hi @anandm08

Thanks for the response , It is showing an error where expected identifier name

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (1)

Report
Copy link

Link copied!

HI @DBO_DV

I would like to use a collection , But is showing an error in my code

Was this reply helpful? Yes No
Verified answer

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
ClearCollect( Dropdownlist, AddColumns( Controls, Value, ControlID & " - " & ControlDescription ) )

Let me know if it helped you.

Here's the Documentation: AddColumns, DropColumns, RenameColumns, and ShowColumns functions - Power Platform | Microsoft Learn

Was this reply helpful? Yes No
Verified answer

anandm08 1,936 Super User 2024 Season 2 on at

Like (2)

Report
Copy link

Link copied!

@Danny_Dicaprio try with ' ' single quotes

Was this reply helpful? Yes No