Power Platform Community Forum Thread Details

Hey

I'm using a list (["1";"2"]) as items for a combox which is placed in a form. I then set the Update value of the form item to Concat(Combobox_value.SelectedItems;Value;",") which creates a string separating the items with a ",". This works fine.

I changed the items of the combobox to Distinct(data;column) which works, I can choose them. However the update formula creates an error. It can not create the string. What am I doing wrong? Feels strange since the data output of the combox has not changed, only the input (which works)?

Categories:

Building Power Apps

When you define a table using the '[<v1>; <v2>; <v3>]' syntax, it's equivalent to the following definition:

Table({ Value: <v1> }; { Value: <v2> }; { Value: <v3> })

In other words - a table with a single column called 'Value'. If you assign it to the Items property of a selectable control such as the combo box, then when you access the 'Selected' (or 'SelectedItems') property, you need to use the '.Value' to access the actual value that was selected.

The Distinct function, however, returns a table with a single column called 'Result', not 'Value', so if you use it in the combo box's Items property, to access the selected value you need to use that property instead. If you update your expression to the one below, you should get the result that you want.

Concat(
 Combobox_value.SelectedItems;
 Result;
 ",")

Community site session details

Update/patch combobox

Helpful resources

News and Announcements

Quick Links

Introducing the 2026 Season 1 community Super Users

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the February Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates