Get currently selected items from a ComboBox

(0) Share

Report

Posted on by pmwhelan

377

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

Categories:

Building Power Apps

I have the same question (0)

All responses (36)

Answers (1)

Sort by

cha_cha 4,932 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @pmwhelan

Remove the quotes on the CompanyTitle.

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

Was this reply helpful? Yes No
pmwhelan 377 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @pmwhelan

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

Replace Title with the actual name of the column.

Was this reply helpful? Yes No
pmwhelan 377 on at

Like
a
(0)

Report
Copy link

Link copied!

"Invalid number of arguments. expected 2 or more"

Was this reply helpful? Yes No
pmwhelan 377 on at

Like
a
(0)

Report
Copy link

Link copied!

I try this ...

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

CompanyTitle isnt recognised.

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Filter(Articles, CompanyTitle.Value in ShowColumns(cbFilterByCompany.SelectedItems,Title))
Try that, I added extra parenthesis earlier.

Was this reply helpful? Yes No
pmwhelan 377 on at

Like
a
(0)

Report
Copy link

Link copied!

The Function ShowColumns has some invalid arguments.

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
pmwhelan 377 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @pmwhelan

So sorry about my answer. I misunderstood your question

First, on your ComboBox, do this to show the company. You don't need to make code changes. Just change the Data Source to the Company list and set Primary Text as Title

Then for your Gallery, use this:
Filter( Articles, CompanyTitle.Value in ShowColumns(ComboBox1.SelectedItems,"Title") )

If you notice you will have a delegation warning, the yellow warning sign. Will send a follow about it soon.

✔️
Just in case my response helped you solve your problem, please mark/accept this as a SOLUTION. This helps community members if they experience a similar issue in the future.

🔗
🕸bistek.space 🐦 @cha_bistek 📺 @BisTekSpace

Was this reply helpful? Yes No