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
a
(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
a
(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
a
(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