You’re offline. This is a read only version of the page.
Hey,
i am working on a PowerApp where i want to Filter and Sort the Items in a dropdown.
Share
ReportSortByColumns('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)
All responses (
Answers (
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.
Ah sorry i forgot.
Yeah i changed them from 500 to 2000. The delegation msg is still the same.
There are about 160 records in the "IT Systemlist" list
What do you mean with same formular.
Hey,
thanks for the quick answer.
Unfortunately i still get the error with that change.
#1
WarrenBelz
292
Most Valuable Professional
#2
MS.Ragavendar
169
#3
stampcoin
130
