Skip to main content

Notifications

Community site session details
Power Apps - Building Power Apps
Answered

Filter and SortbyColumns in a dropdown

Like (0) ShareShare
ReportReport
Posted on 3 Mar 2020 10:58:10 by 11

Hey, 

 

i am working on a PowerApp where i want to Filter and Sort the Items in a dropdown. 

SortByColumns('IT Systemliste';"Title");

Datacard.jpg

 

 

This is the working "SortbyColumns" code. 

I now want to filter the Title by "Lifecycle" and that it shows all except "End of Life" from the Sharepoint list IT Systemliste field "Lifecycle".

 

I tried this one but the "<>" is an invaild argument type.

Filter(SortByColumns('IT Systemliste';"Title");Lifecycle<>"End of Life")

 

not working.jpg

 

 

 

I will add some screenshots from the Lists and the Powerapp that i am using.

 

I also dont know why i have to usw " ; " instead of " , " but it works. 

 

Kind regards. 

 

Patrick

Categories:
  • Verified answer
    WarrenBelz Profile Picture
    147,244 Most Valuable Professional on 07 Mar 2020 at 04:38:21
    Re: Filter and SortbyColumns in a dropdown

    Hi @PatrickPP ,

    The core issue you are getting the Delegation warning on is the <> (not) filter, which is not Delegable.

    While your code should work on small data sets, the easy workaround with 160 items is to create a Collection and then filter it. You can first run this on screen entry (or any other convenient trigger)

    ClearCollect(
     colITList; //or whatever you want ot call it
     'IT Systemliste'
    )

    then your filter will work

    Filter(
     SortByColumns(
     colITSystems;
     "Title"
     );
     Lifecycle<>"End of Life"
    )

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

     

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 298 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 174

#3
stampcoin Profile Picture

stampcoin 138

Overall leaderboard
Loading started
Loading started