Looking if a collection is inside of a column and filter on that

(0) Share

Report

Posted on by efeewfew

302

I have a collection of products that I put in a gallery, that looks like this;

I added a label in the gallery named lblProduct

That collection is basically an array of products. Now I need to filter a gallery based on those values in that collection.

I am currently doing it like this, but it only takes the first product, and not the other products. I want to filter Checklist_Vragen_OpleverApp based on the values in the collection

Filter(Checklist_Vragen_OpleverApp; lblProduct.Text in Product_Type)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Ethan_009 4,838 Moderator on at

Like (0)

Report
Hi @efeewfew ,
Well didn't quite get entire detail but I've created something similar which might help you.
I assume you want to filter all record based on the product type.
//I created 2 collection. 1 collection has products to find. // 2nd collection is list of all products ClearCollect( colProducts, { 'Product Name': "Stalen Hek" }, { 'Product Name': "Baluster" } ); ClearCollect( colListProducts, { Name: "Product A", Type: "Stalen Hek" }, { Name: "Product B", Type: "Stalen Hek" }, { Name: "Product C", Type: "Baluster" }, { Name: "Product D", Type: "Baluster" }, { Name: "Product M", Type: "BlueHill" }, { Name: "Product N", Type: "BlueHill" } );
Now I filtered 2 products from all product list.
Ungroup(ForAll(colProducts, Filter( colListProducts, 'Product Name' in Type ) ),"Value")
This is the Output

Hope this helps

Was this reply helpful? Yes No
efeewfew 302 on at

Like (0)

Report
Hey @Ethan_R

Thank you for your reply and sorry for my late response!

I've been trying to replicate how you made it but I've ran into some issues.

The database for all products with their questions (in your test, this is the collection with all the producttypes & names
I then have a column where I have all of the products that I need to get the questions from;
(This is your colProducts)

I am splitting this column to turn it into a collection;

ClearCollect( collectieProducten; Split(varProducten; ",") );;

I split the values on "," and put them in a collection, result:

Now we need to check if these values are in the database; Checklist_Vragen_Opties (the database with the questions & products)
I tried to do it how you had it, but it shows some questions more than one time & the product name is the same for every label;

Ungroup( ForAll(collectieProducten; Filter( Checklist_Vragen_OpleverApp; Product_Type in collectieProducten ) ); "Value")

I was expecting 6 questions, but I get 9. And the product names are all the same and don't have their actual product name

What am I doing wrong / do I have to add/change?

Thank you in advance! @Ethan_R

Was this reply helpful? Yes No
efeewfew 302 on at

Like (0)

Report

Even if I filter it only on "Baluster", I'd expect to get 2 rows of questions, but I get 6 questions instead.. So weird

If I do it like this, I do get the expected result;

Was this reply helpful? Yes No
efeewfew 302 on at

Like (0)

Report

Anyone able to help me out?

@Ethan_R you maybe? 🙂

Was this reply helpful? Yes No
efeewfew 302 on at

Like (0)

Report

In your ungroup function, I get the error that I can't use a table in there @Ethan_R

Was this reply helpful? Yes No