You’re offline. This is a read only version of the page.
4
Hi All,
I am currently building an app to report issues on machines at our site - I have the following code to view the last 30 days of issues however it will not fetch the data between these dates - I have also tried two date picker boxes but results are the same.
This is on a large data set on a SharePoint list, if I remove the date selection it loads data from 2020
Any help appreciated
With(
{wCode: 'New cell'},
Sort(
Filter(
wCode,
(CellDbox.SelectedText.Value = Cell) &&
(MachineDbox.SelectedText.Value = Machine) &&
(Today()-30 <= Date) &&
(Today() >= Date)
), ID,SortOrder.Descending))
As far as I can see, when you calculate date inside a filter, this calculation make the filter non delegable and will filter the first 2000 itens of your datasource.
Try creating a variable to store the 'Today()-30' and use this variable in your filter.
Let me know if this works
Share
Report
All responses (
Answers (
