I have this query
LastN(Filter('Incident Log',spgCaseID = displayItem.ID),5)
that pulls 5 last records of a SP list. I need to just add sorting to it so that it sorts it decending order. Where do i add that in the query please?
Go to Solution.
SortByColumns(LastN(Filter('Incident Log',spgCaseID = displayItem.ID),5),"spgCaseID", // Use name of column you want to sort by //Descending)
Sorting documentation: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-sort
View solution in original post
Perfect that worked. I just seem to get the comma and things in the wrong places.
Thank you very much
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.