cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mikelpower
Level: Powered On

Multiple filters for gallery items (too many error)

Hello all,

I am  filter a gallery that works fine using:

 

    Filter(DG_tb_Main;S1_Search_WF.Text in WindFarm_Name;
    Substitute(S1_DropDown_Status.Selected.Value;"-All-";"") in Status.Value;
    Substitute(S1_DropDown_Country.Selected.Value;"-All-";"") in Country)
 //   Substitute(S1_DropDown_DataSet.Selected.Value;"-All-";"") in Data_Set_Status.Value   (commented) ///////

 

but when I add the last condition I get an error "Too many arguments" (or so).

 

    Filter(DG_tb_Main;S1_Search_WF.Text in WindFarm_Name;
    Substitute(S1_DropDown_Status.Selected.Value;"-All-";"") in Status.Value;
    Substitute(S1_DropDown_Country.Selected.Value;"-All-";"") in Country;
    Substitute(S1_DropDown_DataSet.Selected.Value;"-All-";"") in Data_Set_Status.Value )

 

I was trying to do something like:

 

    Filter(DG_tb_Main;S1_Search_WF.Text in WindFarm_Name;
    Substitute(S1_DropDown_Status.Selected.Value;"-All-";"") in Status.Value  &&    

    Substitute S1_DropDown_Country.Selected.Value;"-All-";"") in Country &&
    Substitute(S1_DropDown_DataSet.Selected.Value;"-All-";"") in Data_Set_Status.Value )

 

But not working...

 

Any help will very very welcome!!

1 ACCEPTED SOLUTION

Accepted Solutions
mikelpower
Level: Powered On

Re: Multiple filters for gallery items (too many error)

Sorry, I solved myself using "And":

 

Sort(
    Filter(DG_tb_Main;S1_Search_WF.Text in WindFarm_Name;
    Substitute(S1_DropDown_Status.Selected.Value;"-All-";"") in Status.Value And Substitute(S1_DropDown_Country.Selected.Value;"-All-";"") in Country;
    Substitute(S1_DropDown_DataSet.Selected.Value;"-All-";"") in Data_Set_Status.Value And Substitute(S1_DropDown_WindOne.Selected.Value;"-All-";"") in SCADA_Status.Value);
Commissioning_Start_Date;Ascending)

 

Thanks anyway!

1 REPLY 1
mikelpower
Level: Powered On

Re: Multiple filters for gallery items (too many error)

Sorry, I solved myself using "And":

 

Sort(
    Filter(DG_tb_Main;S1_Search_WF.Text in WindFarm_Name;
    Substitute(S1_DropDown_Status.Selected.Value;"-All-";"") in Status.Value And Substitute(S1_DropDown_Country.Selected.Value;"-All-";"") in Country;
    Substitute(S1_DropDown_DataSet.Selected.Value;"-All-";"") in Data_Set_Status.Value And Substitute(S1_DropDown_WindOne.Selected.Value;"-All-";"") in SCADA_Status.Value);
Commissioning_Start_Date;Ascending)

 

Thanks anyway!