cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Emptyglasses
Post Patron
Post Patron

Switch Function

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,

 

Emptyglasses_1-1669972824366.png

 

 

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 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

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?



Signature:


If you appreciated my comments/responses please be sure to Like/Kudo them it really does make me smile 🙂 !
Link to the Power Platform Professionals United Kingdom User Group:

https://powerusers.microsoft.com/t5/Power-Platform-Professionals/gh-p/PowerPlatformProfessionalsUnit...

View solution in original post

9 REPLIES 9
AJ_Z
Super User
Super User

try:

changing it to 

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

 

Try make the V a capital one



Signature:


If you appreciated my comments/responses please be sure to Like/Kudo them it really does make me smile 🙂 !
Link to the Power Platform Professionals United Kingdom User Group:

https://powerusers.microsoft.com/t5/Power-Platform-Professionals/gh-p/PowerPlatformProfessionalsUnit...

HI , 

Thanks for the reply 

But it is showing some error

Emptyglasses_0-1669973407139.pngEmptyglasses_1-1669973461023.png

 

AJ_Z
Super User
Super User

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



Signature:


If you appreciated my comments/responses please be sure to Like/Kudo them it really does make me smile 🙂 !
Link to the Power Platform Professionals United Kingdom User Group:

https://powerusers.microsoft.com/t5/Power-Platform-Professionals/gh-p/PowerPlatformProfessionalsUnit...

its a choice column

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.

 

 



Signature:


If you appreciated my comments/responses please be sure to Like/Kudo them it really does make me smile 🙂 !
Link to the Power Platform Professionals United Kingdom User Group:

https://powerusers.microsoft.com/t5/Power-Platform-Professionals/gh-p/PowerPlatformProfessionalsUnit...

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 

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?



Signature:


If you appreciated my comments/responses please be sure to Like/Kudo them it really does make me smile 🙂 !
Link to the Power Platform Professionals United Kingdom User Group:

https://powerusers.microsoft.com/t5/Power-Platform-Professionals/gh-p/PowerPlatformProfessionalsUnit...

Yeppp , that worked perfectly fine 

Thanks man for your support 

No worries at all I am happy to help 🙂

 

and good luck with your app 🙂



Signature:


If you appreciated my comments/responses please be sure to Like/Kudo them it really does make me smile 🙂 !
Link to the Power Platform Professionals United Kingdom User Group:

https://powerusers.microsoft.com/t5/Power-Platform-Professionals/gh-p/PowerPlatformProfessionalsUnit...

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,712)