Answered

Switch Function

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

All responses (9)

Answers (1)

Sort by

AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

try:

changing it to

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

Try make the V a capital one
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

HI ,
Thanks for the reply
But it is showing some error
AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

its a choice column
AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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
Verified answer

AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Yeppp , that worked perfectly fine
Thanks man for your support
AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

No worries at all I am happy to help 🙂

and good luck with your app 🙂