Answered

Help with filters/collection

(0) Share

Report

Posted on by bennstef

I am trying to filter the gallery by the 2 drop downs, however my collection won't work currently (the records are not being added from either entity). Can anybody see where I am going wrong?

Any help is much appreciated I have been banging my head against the wall for a while now!!

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @bennstef ,

I made a test on my side based on your scenario, please try with the following code.

Put the following code to Gallery.Items property.

Filter( SKUs, 'Product Family'.'Product Family' in 'Demand Families'.'Product Family', 'Product Family'. 'Family Name'=LeftDropdown.Selected.Result, Colour=RightDropdown.Selected.Result )

Sik

Was this reply helpful? Yes No
bennstef 36 on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you for the help dude. I have implemented the above solution with no luck 😞

If I comment out these two lines:

//'Product Family'.'Product Family' in 'Demand Families'.'Family Name', //'Product Family'.'Family Name' = Dropdown1.Selected.Result,

Then results will appear, so must be something going wrong here ^

(Demand families has been added as a data source just to clarify that)

Any ideas?

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @bennstef ,

How many rows in SKUs entity?

Since the formula is not delegable, If it has more than 500 rows records, please try to increase the threshold of non-delegable queries to 2000.

Please let me know if it works for your case.

Sik

Was this reply helpful? Yes No
bennstef 36 on at

Like
a
(0)

Report
Copy link

Link copied!

There is only about 10 records in their atm 😕

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @bennstef ,

Ok, maybe I misunderstood something.

Could you please elaborate more about what does the filter condition mean?

Product Family in SKUs entity is a lookup field, related to Demand Families entity. I cannot figure out what's the intention of this filter formula.

Sik

Was this reply helpful? Yes No
bennstef 36 on at

Like
a
(0)

Report
Copy link

Link copied!

This was an attempt to include to the product family/name from Demand families into a new collection with SKUs. (Someone suggested to try it this way).

I have removed this code as it looked like the solution you provided did not need this code.

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @bennstef ,

From my view, this filter condition doesn't make any sense, because as long as product family field is not null, this filter condition is always true.

Will the gallery work properly after removing this part of the code?

Sik

Was this reply helpful? Yes No
bennstef 36 on at

Like
a
(0)

Report
Copy link

Link copied!

I removed this code when I tried your solution with no luck dude.

Not sure why it won't work its spot on with your code and you have a working example 😞

*Continues to bang head against wall*

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @bennstef ,

Did you check the entity data? Are there any record that meet these filtering criteria?

Filter( SKUs, 'Product Family'. 'Family Name'=LeftDropdown.Selected.Result, Colour=RightDropdown.Selected.Result )

Sik

Was this reply helpful? Yes No