Unanswered

Filter Gallery (SharePoint List) with Multiple Values from Other SharePoint List

(0) Share

Report

Posted on by A_Rodgers

Hi,

I have a SharePoint List with Languages and the Products available in those languages. I have another list called Product Packages and the Products that compose those packages. Products is also a SharePoint list and is connected to Languages and Product Packages as a look up column.

I need to filter Languages for all Products in a selected Product Package. I am able to select a single product and filter languages with this expression.

If(Dropdown1_4.Selected.Title = "No Filter",'Languages - Complete', Filter('Languages - Complete', Dropdown1_4.Selected.Title in Products.Value))

I am not able to figure out how to filter Languages for all Products in a selected Product Package (dropdown). I have had minor success by translating the product titles into an html text box and filtering Languages with text in the text box, however several items are missed because it searches for the literal string and there are variations in placement/punctuation.

This is the code for adding the Product titles from the selected Product Package to a text box

If(Dropdown1.Selected.Title = "No Filter", "", Concat(Dropdown1.Selected.Products,Value,";"))

This is the code that kind of filters based on the string in the text box

If(Dropdown1.Selected.Title = "No Filter",'Languages - Complete', Filter('Languages - Complete', HtmlText1.HtmlText in Concat(Products,Value & ";")))

Anyone have advice for filtering for all records between tables? Thank you in advance for the help!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

CU24091509-0 417 on at

Like (0)

Report

@A_Rodgers Do you mind sharing a screenshot of the your app screen with dropdowns?

Was this reply helpful? Yes No
A_Rodgers 2 on at

Like (0)

Report
Sorry, my first post disappeared.
@KranthiTupakula here are screenshots and more explanation.
I tried another route with a duplicate screen, still with no success.
Both screens have this code onVisible
ClearCollect(collectPackages,{Title:"No Filter"});Collect(collectPackages,SortByColumns('Product Packages',"Title"));
The dropdowns are
collectPackages
On screen 1, I'm trying to directly filter the gallery based on the products in the package selected in the dropdown.

If(Dropdown1.Selected.Title = "No Filter",'Languages - Complete', Filter('Languages - Complete', ForAll(Dropdown1.Selected.ProductsInPKG.Value) in Products.Value))
On screen 2, I added a data table of the Products list, and filtered that table based on the package selected in the dropdown
data table Items
If(Dropdown1_1.Selected.Title = "No Filter", Products, Filter(Products, Dropdown1_1.Selected.Title in Packages.Value))
gallery items
If(Dropdown1_1.Selected.Title = "No Filter",'Languages - Complete', Filter('Languages - Complete', ForAll(DataTable1.Selected.Title in Products.Value)))

Some more explanation of the SharePoint Lists. All lookup columns are multiselect. Languages has a lookup to Products, Products has a lookup to Packages (added to make the data table work), Packages has a lookup to Products. The app needs to filter based on AND, so for example if a package has products 1, 2, and 3, and the products are available in the following languages, then only the languages listed in all 3 packages should show (A and C in this example).
product1 product2 product3
language a language a language a
language b language b language c
language c language c
language d

Was this reply helpful? Yes No