Dropdown Value - All Items to Text

(0) Share

Report

Posted on by Priyanka09

Would really appreciate some help here--

I've a dropdown that filters values from a table. Is there a way to concat all items in a dropdown to a textbox/label?

Note: All values and not just the selected value.

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Gopala_Krishna 1,495 on at

Like (0)

Report
Copy link

Link copied!

@Priyanka09

You can use the concat expression to convert all the values select into a text.

Concat(ComboBox1.SelectedItems.Value,Value,",")

Contact accepts a single column table as input, you can enter the combobox/dropdownname.SelectedItems/Selected.Value and the second parameter is also the same it takes expression or you can select column name and third parameter is separator.

For more info - Concat and Concatenate functions - Power Apps | Microsoft Docs

If the information shared helps you, please consider giving a thumbs up 👍 and mark solution as resolved.

Was this reply helpful? Yes No
Priyanka09 28 on at

Like (0)

Report
Copy link

Link copied!

Thank you @Gopala_Krishna . Unfortunately what I'm looking for is not concatenating the selected values but concatenating All values in a combo-box/dropdown which might NOT be selected by the user.
Eg: dropdown/combobox has values:1,2,3,4,5 etc. User has not made any selection. I want to concat these values into text. Is there a way to do that?

Was this reply helpful? Yes No
Gopala_Krishna 1,495 on at

Like (1)

Report
Copy link

Link copied!

@Priyanka09

You can use the same concat expression to achieve that, instead of putting the selected values expression you can put the expression what you have specified on the combobox/dropdown using which you are displaying the values.

If you have [1,2,3,4,5] in a dropdown and if user selects 1 and you want to display only [2,3,4,5] in the text then you can perform filter where you remove the selected value from the list of values and then concat the result.

If the information shared helps you, please consider giving a thumbs up 👍 and mark solution as resolved.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi@Priyanka09,
Based on the issue that you mentioned, do you want to concatenate all the options in the dropdown?
Could you please share a bit more about your scenario:
what is the column type corresponding to the column you populate the dropdown?
how you set the Items property of the dropdown?
// If this is a Choice column, please check the following workaround.
In my scenario, I set the Items property of the Dropdown as below:

Choices(Test1224.Choices)

I set the Text property of the Label as below:

Concat(Choices(Test1224.Choices),Value,",")

// If this is a Text column, please check the following workaround.
In my scenario, I set the Items property of the Dropdown as below:

Distinct(Test1224,Text)

I set the Text property of the Label as below:

Concat(Distinct(Test1224,Text),Result,",")

Note: I use the Distinct() function to get the distinct options.
Hope it could help.
Best Regards,
Qi

Was this reply helpful? Yes No