Switch Function

[Emptyglasses]

My app has few tabs and a gallery in homescreen, on the selection of tabs I want to sort the data in the gallery on the basis of certain condition 

1 clicking on the first tab will display the entire data from  sharepointlist in the gallery

* when clicking on the fourth tab , I want to filter the data in my sharepoint list , But it is showing some error,

SUPD is  my sharepoint list , by clicking on the fourth tab i need to show all the data which contains the " Rejected"

4,Filter(SUPD,Contains.value="Rejected"))

Could anyone help me to fix this 

[AJ_Z]

try:

changing it to 

Filter(SUPD,Contains.Value="Rejected"))

Try make the V a capital one

[Emptyglasses]

HI , 

Thanks for the reply 

But it is showing some error

[AJ_Z]

Oh I misunderstood your question apologies. 

what is the name of the column we are checking contains rejected?

and is it a text column or a choice column

[Emptyglasses]

its a choice column

[AJ_Z]

What is the name of the choice column is it 'Ticket Status'?

what rejected options are there for the choice is it just rejected if so we can use = or if its multiple options that contain the word rejected we can use contains.

[Emptyglasses]

HI, 

Actually I've 5 choice column which have the options  ""Rejected"" 

is it possible to show by clicking on the 4th Tab can the sharepoint list can be filtered  with the word " rejected " without mentioning the column names 

[AJ_Z · Accepted solution]

Why can we not mention the column names ? 

would it not be simpler to do:

Filter(SUPD,Or('Column 1'.Value="Rejected",'Column 2'.Value="Rejected",'Column 3'.Value="Rejected",'Column 4'.Value="Rejected",'Column 5'.Value="Rejected")))

this way if any say rejected they appear?

[Emptyglasses]

Yeppp , that worked perfectly fine 

Thanks man for your support 

[AJ_Z]

No worries at all I am happy to help 🙂

and good luck with your app 🙂