Hi Mates,
There are three listboxes(lstb1,lstb2,lstb3) and two textboxs(txtfrom, txtTo) field is Weight (ex. 1-100, 200-500 etc.)
Input Parameters : listbox(lstb1,lstb2) items and textbox with From -To Values.
OutPut : Listbox3(lstb3)
Action/Trigger : Button to filter on lstb3
lstb1 loading Table.type Vaues Item: Distinct(Filter(Table,Type <>""),Type)
lstb2 loading Table.source Values item: Distinct(Filter(Table,Source <>""),Source)
lstb3 loading Table.Location Values item:
if(CountRows(Gallery.Allitems)=0,Distinct(Filter(Table,Location <>""),Location),filterColl)
here we also have two textboxs to filter lstb3 values based textboxs.
Button : OnSelect :
ClearCollect(filterColl,Distinct(Filter('Table,Weight>Value(txtfrom.Text),Weight<Value(txtto.Text)),Location));
Current behavior in shot:
lstb3 is loading default values Location : this is correct as expected
selecting items from lstb1, lstb2 and input from -to values then only lstb3 loading/Filtering when press the button but
how to load/filter values when selected lstb1,lstb2 items with out From -To values.
Means user want to filter lstb3 on two condtion
1. when select the input parameters from lstb1, lstb2 items And txtfrom -txtTo(weight) values.
2. when select the input parameters from lstb1, lstb2 items
when trigger/button clicks then above condition 1 is filtering location values working as expected. But user also want to filter
with-out entering From-To Values, means only with lstb1,lstb2 items
how to filter with skip if From-To is blank, if not Blank then consider From-To textbox values in the same button.
With the above button formula i can filter when only enter the From-To values but not with blank.
Any body can help me here.
how can apply filter if From-To is blank then filter based lstb1,lstb2 values, if not Blank then consider From-To textbox values in the same button. kindly help me code.
