Convert combo box selected items into a string

[Brian_]

I'm trying to send the selected items in a combo box to a string for output. I know I can out individual selected items several different ways but I can't figure out how to convert all of them into one contiuous string.

I can show the first;

First(ComboBox1.SelectedItems).Title

Or the last;

Last(ComboBox1.SelectedItems).Title

And I can find the number of selected items;

CountA(ComboBox1.SelectedItems.Title)

But how do I get the first last and everything in between?

[sludgeza]

Please explane how this is used?

[csegovia]

To strip off the trailing comma: not the most elegant solution but it does the job

Left(Concat(ComboBox1.SelectedItems, Value & ","),Len(Concat(ComboBox1.SelectedItems, Value & ","))-1)

[WillPage]

@csegoviaIt works pretty well. I wouldn't call it inelegant, when you consider the sort of monstrosities that can come out of the expression builder in Flow.

[cweaver]

For those of you using an external source for your combo box items, I'd like to amend csegovia's formula to:

Left(Concat(YourComboBox.SelectedItems,Result&", "),Len(Concat(YourComboBox.SelectedItems,Result&", "))-2)

[CindyZ]

Perfect, thank you!

[CindyZ]

@cweaver Could you please tell me how you would add Left and Len into this formula.  I have not been able to resolve it so I can remove the trailing comma.  Thank you.  

Concat(cmbxEventSponsoringChapter.SelectedItems,(Concatenate(Acronymn,", ")))

[CindyZ]

This is what I resolved this with. 
Left(Concat(cmbxEventSponsoringChapter.SelectedItems,(Concatenate(Acronymn,", "))),Len(Concat(cmbxEventSponsoringChapter.SelectedItems,(Concatenate(Acronymn,", "))))-2)

[SSISJoost]

Here is some example code for combobox items. List of ID's separated with a comma: 

Concat(
    ComboBox_multiselect.SelectedItems.ProductKey,
    Concatenate(
        Text(ProductKey),
        ","
    )
)

 and to get rit of the last (unwanted) comma:

Left(
    Concat(
        ComboBox_multiselect.SelectedItems.ProductKey,
        Concatenate(
            Text(ProductKey),
            ","
        )
    ),
    Len(
        Concat(
            ComboBox_multiselect.SelectedItems.ProductKey,
            Concatenate(
                Text(ProductKey),
                ","
            )
        )
    ) - 1
)

This results in a list of the ID's of the selected combo items, for example in a label:

[cycle4passion]

Sorry already solved above

You just need to take he last 2 characters off the string:

Left( Concat(ComboBox.SelectedItems, Product & ", " ), Len( Concat(ComboBox.SelectedItems, Product & ", " ) ) - 2 )

[_Ken]

@WillPage  Try this:

Concat(ComboBox1.SelectedItems, Text(Product), ", ")