filter gallery by number range

(0) Share

Report

Posted on by Edward00

122

I wanted to filter Price by range so I tried using this but it crashed:

My code of Items in Gallery:

With( {ctxRange:ComboBox5.Selected.range},
Sort(
 Filter(
 Product,
 If(
 CountRows(ctxRange)>1,
 Price>Index(ctxRange,1).Value&&Price<=Index(ctxRange,2).Value,
 Price>=Index(ctxRange,1).Value
 ),
 StartsWith(
 Title,
 tbSearchProduct.Text
 ) || StartsWith(
 Manufacturer,
 tbSearchProduct.Text
 ),
 (Manufacturer = cmb_ManuShopping.Selected.Value || cmb_ManuShopping.Selected.Value = Blank()) && (Category = cmb_CateShopping.Selected.Value || cmb_CateShopping.Selected.Value = Blank()) && (ShoeHeight.Value = cmb_ShoeHeight.Selected.Value || cmb_ShoeHeight.Selected.Value = Blank())
 ),
 Price,
 If(
 ComboBox2.Selected.Value = "Low-High",
 SortOrder.Ascending,
 SortOrder.Descending
 )
))

Is there a way to fix that warning?

I hope everyone can help. Thank you.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Edward00 ,

Please try:

With( {ctxRange:ComboBox5.Selected.range}, With( { countRowsctxRange:CountRows(ctxRange), ctxRange1:Index(ctxRange,1).Value ctxRange2:Last(ctxRange).Value }, Sort( Filter( Product, If( countRowsctxRange>1, Price>ctxRange1&&Price<=ctxRange2, Price>=ctxRange1 ), StartsWith( Title, tbSearchProduct.Text ) || StartsWith( Manufacturer, tbSearchProduct.Text ), (Manufacturer = cmb_ManuShopping.Selected.Value || cmb_ManuShopping.Selected.Value = Blank()) && (Category = cmb_CateShopping.Selected.Value || cmb_CateShopping.Selected.Value = Blank()) && (ShoeHeight.Value = cmb_ShoeHeight.Selected.Value || cmb_ShoeHeight.Selected.Value = Blank()) ), Price, If( ComboBox2.Selected.Value = "Low-High", SortOrder.Ascending, SortOrder.Descending ) ) ))

Best Regards,

Bof
Edward00 122 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft
It's still being warned.
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Edward00 ,

Maybe you could try:

With( {ctxRange:ComboBox5.Selected.range}, With( { countRowsctxRange:CountRows(ctxRange), ctxRange1:Index(ctxRange,1).Value ctxRange2:Last(ctxRange).Value }, Sort( If( countRowsctxRange>1, Filter( Product, Price>ctxRange1&&Price<=ctxRange2, StartsWith( Title, tbSearchProduct.Text ) || StartsWith( Manufacturer, tbSearchProduct.Text ), (Manufacturer = cmb_ManuShopping.Selected.Value || cmb_ManuShopping.Selected.Value = Blank()) && (Category = cmb_CateShopping.Selected.Value || cmb_CateShopping.Selected.Value = Blank()) && (ShoeHeight.Value = cmb_ShoeHeight.Selected.Value || cmb_ShoeHeight.Selected.Value = Blank()) ), Filter( Product, Price>=ctxRange1, StartsWith( Title, tbSearchProduct.Text ) || StartsWith( Manufacturer, tbSearchProduct.Text ), (Manufacturer = cmb_ManuShopping.Selected.Value || cmb_ManuShopping.Selected.Value = Blank()) && (Category = cmb_CateShopping.Selected.Value || cmb_CateShopping.Selected.Value = Blank()) && (ShoeHeight.Value = cmb_ShoeHeight.Selected.Value || cmb_ShoeHeight.Selected.Value = Blank()) ) ), Price, If( ComboBox2.Selected.Value = "Low-High", SortOrder.Ascending, SortOrder.Descending ) )))

In addition, if your data source is sql sever ,then >,>=,<,<= is not delegable for DateTime column.

Best Regards,

Bof