Hello,
I would like to filter and sort a data table.
I have a SharePoint list which contains, among other things, a Quantity and Date column. In a data table, I would like to filter by this quantity and sort the date.
I do it like this: SortByColumns(Filter('SPList';SPColumnAmount = currentAmount); "Date";SortOrder.Ascending)
SPList --> connected SharePOint list
SPColumnAmount --> column in the SharePoint list (number)
currentAmount --> Variable in the PowerApp (number)
Date --> Column in the data table, which comes from the SharePointList
But it only works after I load and jump back to the table several times, not right away. Does anyone know the reason for this or how I can filter and sort better?