I am trying to set up a simple email report to be sent out 1x a day in the morning with all new items from a SharePoint list, either in the past 24h or the day before. Would anyone be able to help a beginner?
In the GetItems filter query, I have tried both addDays(...) with "yyyy-mm-dd" and formatDateTime(getPastTime(...)) with "yyyy-MM-ddTHH:mm:ss" and I keep getting the error:
The expression "Date Created ge '2023-11-19T09:28:03'" is not valid. Creating query failed.
clientRequestId: 9e74da3c-f876-4d23-8174-a8b8f421063c
serviceRequestId: 9e74da3c-f876-4d23-8174-a8b8f421063c
When I changed the column name to the backend name "_DCDateCreated" it returned the error "column does not exist"
My Sharepoint settings are English (UK) with dd-mm-yyyy format, and my current UTC is +1.
OR
Thank you for any tips on fixing this!
