Answered

Filtering a Gallery from concatenated SharePoint entries

(0) Share

Report

Posted on by NatWalton01

Hi, I need some help filtering a gallery.

The Client will use a combobox to select potencially multiple 'Markets' which are then concatenated when patched into a SharePoint to keep them as one entry.

Concatenated like this {Product:Concat(cbProduct.SelectedItems,Products," ; ")},

I am wondering if it is possible to filter a gallery by searching for the markets , using a dropdown box to select them. I have it working when there is just a single market but not for multiple.

And advice on this or another way to do this would be helpful.

Cheers

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Consider:

With({ColDatasource: cbProduct},
Filter(ColDatasource, Dropdown.Selected.Product in Product))

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Please Subscribe to my Youtube Channel
NatWalton01 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, Could you please explain the function of this? It is not being accepted as it is.
Also the input for the filter is a ComboBox

Thank you
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Show the formula on the Combobox and the formulas that is giving you error.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @NatWalton01 ,

I did a test for you.

Add a gallery control and set its Items property to:

Filter(ForAll(LIST173 As A,If(CountRows(Filter(ForAll(ComboBox1.SelectedItems As B,If(B.Value in A.Title,{Value2:1})),!IsBlank(Value2)))=CountRows(ComboBox1.SelectedItems),A)),!IsBlank(ID))

Best Regards,

Wearsky