Hi
I pull through data into a DataTable from a large SharePoint list and filter based on the Current User logged in.
SortByColumns(Filter('Toolbox', StartsWith(Name, 'Pull-Through-Current-User'.Text)),"Title",If(SortDecending,Ascending,Descending))
This works ok but I've been trying to amend this so that additionally it only pulls through records for the current year but I get Delegation warning.
Columns available in SharePoint that I can filter on are;
Date. = Calculated Column - Date as Text DD/MM/YYYY
Year = Calculated Column - Date as YYYY
Date = Date value
I've also tried adding a DropDown instead to filter but again I get a Delagation warning.
Any ideas welcomed.
