Answered

Switch Function

(1) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

AJ_Z 3,711 Super User 2024 Season 1 on at

Like (1)

Report

try:

changing it to

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

Try make the V a capital one

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

Like (1)

Report

HI ,
Thanks for the reply
But it is showing some error

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like (1)

Report

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

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

Like (1)

Report

its a choice column

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like (1)

Report

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.

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

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

AJ_Z 3,711 Super User 2024 Season 1 on at

Like (1)

Report

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?

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

Like (1)

Report

Yeppp , that worked perfectly fine
Thanks man for your support

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like (0)

Report

No worries at all I am happy to help 🙂

and good luck with your app 🙂

Was this reply helpful? Yes No