Solved: Unable to concat Combobox Selected Items

Knight23 · ‎10-22-2020

Hi everyone,

So, I have a dropdown in which I select a single option for both and a Combobox that displays some results that depend on the selected item of the dropdown. In ths combobox I can choose several items but I have an issue trying to Concat and save it into a Collection. All the information comes from a Sharepoint List called "Geografia".

My dropdown contains the next formula in it's Items property:

Sort(Distinct('Geografia';Nombre);Result)

While the Combobox looks quite different:

Distinct(Filter('Geografia';Region=Dropdown.Selected.Result);Centro))

The issue is that if I set a label with the following formula:

Concat(ComboBox.SelectedItems;",")

The result looks like this: , , ,

timl · ‎10-23-2020

That sounds like good progress! At this point, you should be able to recombine your formula like so.

In the formula, I would also make sure to spell "Value" with a capital V, because it'll be case sensitive when you refer to the selected items in your call to Concat.

If(!IsBlank(DD_Zona_5.Selected.Result);
    AddColumns(
           Distinct(Filter('Geografia';Region=DD_Zona_4.Selected.Result);Nombre_Centro));
           "Value";
           Result.Value
    );
    Choices([@'Geografia PD'];Nombre_Centro)
)

View solution in original post

timl · ‎10-22-2020

Hi @Knight23

Can you try the following to see if that works better for you?

Concat(ComboBox.SelectedItems; Centro & ",")

Knight23 · ‎10-22-2020

Hi @timl ,

I tried as you mentioned but I get the next message:

"Invalid name. Cannot recognize the identifier. This error appears when a formula references an element that no longer exists"

I also tried using Thisitem.Centro and ThiRecord as they're listed in the options and I get the following error:

"Invalid argument. One of the following was expected: Text, Number, Boolean, OptionSetValue, ViewValue."

My combobox is set inside a gallery and the source Sharepoint column is a list of options

timl · ‎10-22-2020

Hi @Knight23

Thanks for clarifying this. Does this work any better?

Concat(ComboBox.SelectedItems; Result & ",")

Knight23 · ‎10-22-2020

Doesn't seem to work either 😞

I get the same "invalid name/unknown identifier" message.

timl · ‎10-22-2020

Hi @Knight23

So that we diagnose this further, can you store the results in a collection so that we can see the column headers?

To do this, add a button inside your gallery where your combobox is and set the OnSelect property to the following:

ClearCollect(colTest; ComboBox.SelectedItems)

If you select some items in your Combobox and click the button, can you view the colTest collection in the File > Collections menu, check that it contains the items that you expect, and post a screenshot of what you see here?

Knight23 · ‎10-22-2020

Interesting, I selected 5 items in the combobox, collected them as you suggested and the result is as follow:

There's no collection at all.

timl · ‎10-22-2020

That's useful because that explains why your call to Concat doesn't work!

The next step is to work out why this is showing up as empty. Can you confirm that ComboBox is definitely the name of the combobox in your gallery?

Knight23 · ‎10-22-2020

Yes! Combobox is definetly the name of my combobox.

timl · ‎10-22-2020

In your label, if you type the following...

First(ComboBox.SelectedItems).

can you confirm or screenshot the column name suggestions that appear in the formula bar after the dot symbol?

Unable to concat Combobox Selected Items

Helpful resources

Manage your user group events

Check it out!

2021 Release Wave 2 Plan

Microsoft Learn