Help with filters/collection

[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!!

[v-siky-msft · Accepted solution]

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

[bennstef]

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?

[v-siky-msft]

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

[bennstef]

There is only about 10 records in their atm 😕 

[v-siky-msft]

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 

[bennstef]

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. 

[v-siky-msft]

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

[bennstef]

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*

[v-siky-msft]

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