Hey,
i am working on a PowerApp where i want to Filter and Sort the Items in a dropdown.
SortByColumns('IT Systemliste';"Title");
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")
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
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.
WarrenBelz
298
Most Valuable Professional
MS.Ragavendar
174
stampcoin
138