Switch Function

[Emptyglasses]

Hi ,

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 second tab , I want to filter the data in my sharepoint list , But it is showing some error,

Access Details is a choice column in my sharepoint list , by clicking on the second tab I only want to show the data where the Accessdetails column contains the value Display

Could anyone help me to fix this 

[NandiniBhagya20 · Accepted solution]

Hi @Emptyglasses ,

Try using below formula - 

Switch(vartabselected, 1, SPUD, 2, Filter(SPUD, 'Access Details'.Value="Display"))

[Emptyglasses]

Hi,

Thanks for the reply that worked perfectly fine 

[Emptyglasses]

Hi I;ve one more doubt 

what if I need to sort the data not based on column , On shrepoint list 

like i need need to showcase all the data in my app if my Sharepoint list contains the word Display

Switch(vartabselected, 1, SPUD, 2, Filter(SPUD, .Value="Display"))

 will this work ??