Filtering a gallery based on what is selected in a multi select combobox.

(0) Share

Report

Posted on by Blarue

I have a document library housed on SharePoint with a text column containing a string of names separated by commas. In my Canvas Power App I have a combobox with a list of choices and a Gallery where I want to display my document library.

I want to filter the document library based on the selected items in the combo box. If any of the selected items in the combo box are present in the list of names in the SharePoint text column I want that document to be in the Gallery.

This is what i have in my Items control of the Gallery

Filter('My Document Library', My_combobox.SelectedItems.'Name ({Name})' in 'MySharePointColumn')

'Name ({Name})' is the name of the field in my Combobox where the value i want to check if it is in my SharePoint text column is located.

this approach has usually worked for me but this time i am getting this error " Cannot use Table values in this context"

what am i doing wrong here?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

WarrenBelz 155,544 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Blarue ,

You have a many-to-many relationship there - note also this is not Delegable, nor can you make it so when you need to use the in filter.

Ungroup( ForAll( My_combobox.SelectedItems As _Data, Filter( 'My Document Library', _Data.'Name ({Name})' in 'MySharePointColumn' ) ), "Value" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No