Answered

Convert combo box selected items into a string

Like (6) Share

Report

Posted on 19 Jun 2018 21:48:39 by 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?

All responses (21)

Answers (1)

Ash26 on 29 Feb 2024 at 12:22:29

Like (0)

Report

Re: Convert combo box selected items into a string

What if your combo box is not connected to any tables? and you are using local Item value?
allan_t 300 on 14 Nov 2023 at 21:16:35

Like (0)

Report

Re: Convert combo box selected items into a string

@Brian_ Thank you, you saved me after an hour of troubleshooting.
_Ken 120 on 13 Jul 2021 at 06:07:14

Like (1)

Report
Re: Convert combo box selected items into a string

@WillPage Try this:
Concat(ComboBox1.SelectedItems, Text(Product), ", ")
cycle4passion 94 on 16 Jan 2021 at 18:27:03

Like (1)

Report

Re: Convert combo box selected items into a string

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 )
SSISJoost 21 on 03 Jan 2021 at 21:25:18

Like (1)

Report
Re: Convert combo box selected items into a string

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:
CindyZ on 03 Jan 2021 at 18:35:53

Like (1)

Report

Re: Convert combo box selected items into a string

This is what I resolved this with.
Left(Concat(cmbxEventSponsoringChapter.SelectedItems,(Concatenate(Acronymn,", "))),Len(Concat(cmbxEventSponsoringChapter.SelectedItems,(Concatenate(Acronymn,", "))))-2)
CindyZ on 29 Dec 2020 at 19:20:50

Like (0)

Report

Re: Convert combo box selected items into a string

@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 on 27 Dec 2020 at 13:54:52

Like (0)

Report

Re: Convert combo box selected items into a string

Perfect, thank you!
cweaver 98 on 25 Sep 2020 at 21:41:48

Like (1)

Report
Re: Convert combo box selected items into a string

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)
WillPage 1,909 on 23 Oct 2019 at 02:54:35

Like (0)

Report

Re: Convert combo box selected items into a string

@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.