Answered

Switch Function

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,
Try using below formula -
Switch(vartabselected, 1, SPUD, 2, Filter(SPUD, 'Access Details'.Value="Display"))

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,
Thanks for the reply that worked perfectly fine

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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 ??

Was this reply helpful? Yes No