Answered

Switch Function

Like (1) Share

Report

Posted on 2 Dec 2022 09:23:23 by Community Power Pla...

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

Categories:

All responses (9)

Answers (1)

AJ_Z 3,711 Super User 2024 Season 1 on 02 Dec 2022 at 10:02:27

Like (0)

Report

Re: Switch Function

No worries at all I am happy to help 🙂

and good luck with your app 🙂
Community Power Pla... on 02 Dec 2022 at 10:00:22

Like (1)

Report

Re: Switch Function

Yeppp , that worked perfectly fine
Thanks man for your support
Verified answer

AJ_Z 3,711 Super User 2024 Season 1 on 02 Dec 2022 at 09:49:11

Like (1)

Report

Re: Switch Function

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?
Community Power Pla... on 02 Dec 2022 at 09:44:50

Like (1)

Report

Re: Switch Function

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 3,711 Super User 2024 Season 1 on 02 Dec 2022 at 09:40:22

Like (1)

Report

Re: Switch Function

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.
Community Power Pla... on 02 Dec 2022 at 09:36:14

Like (1)

Report

Re: Switch Function

its a choice column
AJ_Z 3,711 Super User 2024 Season 1 on 02 Dec 2022 at 09:35:08

Like (1)

Report

Re: Switch Function

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
Community Power Pla... on 02 Dec 2022 at 09:31:18

Like (1)

Report

Re: Switch Function

HI ,
Thanks for the reply
But it is showing some error
AJ_Z 3,711 Super User 2024 Season 1 on 02 Dec 2022 at 09:25:31

Like (1)

Report

Re: Switch Function

try:

changing it to

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

Try make the V a capital one