Hello, I have created an APP for checking & reporting of Car Milage twice a day by 50+ staff members. After running the app for almost 6 months, the number of rows of the SP List is now over 4,400.
I've set a delegation at my APP for retrieving only those records in the past 5 days with the formula below but it however doesn't work!!!
If(
IsBlank( TextSearchBox1.Text),
SortByColumns(
Filter(
'Company Vehicle Milage Records',
'Technician Name' = Office365Users.MyProfileV2().displayName &&
DateValue('Report Date') >= DateAdd(Today(), -5)
),
"ID", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending)
),
SortByColumns(
Filter(
'Company Vehicle Milage Records',
Switch(
ComboBox1.Selected.Val,
1, TextSearchBox1.Text in 'Technician Name',
2, TextSearchBox1.Text in 'Car Plate Number',
3, TextSearchBox1.Text in Area
) &&
DateValue('Report Date') >= DateAdd(Today(), -5)
),
"ID", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending)
)
)
Much appreciate your advice on making this formula functionable.
Thanks
Raymond