Get currently selected items from a ComboBox

[pmwhelan]

Hi

I have two lists in SharePoint Online.

Companies and Articles.

There can be numerous Articles about a Company.

In the Articles list there is a Lookup to the Company List value "Title".

I am trying to filter the Articles Gallery by Company.

I created a Combo Box "cbFilterByCompany" with

DefaultSelectedItem = Choices(Articles.CompanyTitle)

And a Label with

Concat(cbFilterByCompany.SelectedItems, "CompanyTitle", ",")

But it just shows the text "CompanyTitle,CompanyTitle,CompanyTitle,CompanyTitle,CompanyTitle"

Also the Combo Box isn't displaying the names of the Companies (and it seems to be trying to show the names of comanies multiple times as there can be multiple articles about the same company)

thanks

P

[cha_cha]

Hello @pmwhelan 

Remove the quotes on the CompanyTitle.

Concat(cbFilterByCompany.SelectedItems, CompanyTitle, ",")

[pmwhelan]

Many thanks.

Do you know how I'd filter the items in the gallery?

I try

Filter(Articles, CompanyTitle.Value in cbFilterByCompany.SelectedItems)

but it says expected a one-column table.

Thanks

[cha_cha]

Hello @pmwhelan 

Filter(Articles, CompanyTitle.Value in ShowColumns(cbFilterByCompany.SelectedItems),Title))

Replace Title with the actual name of the column.

[pmwhelan]

"Invalid number of arguments. expected 2 or more"

[pmwhelan]

I try this ...

Filter(Articles, CompanyTitle.Value in cbFilterByCompany.SelectedItems.CompanyTitle)

CompanyTitle isnt recognised.

[cha_cha]

Filter(Articles, CompanyTitle.Value in ShowColumns(cbFilterByCompany.SelectedItems,Title))

Try that, I added extra parenthesis earlier.

[pmwhelan]

The Function ShowColumns has some invalid arguments.

[cha_cha]

What's the name of the column of your company title?

[pmwhelan]

In the Articles List I have a CompanyTitle column (which is a lookup to the Company list - it can also be multiselect)

thanks