Hello, I am hoping you can assist me.
I am trying to write a sharepoint flow and am having issues with Filter Queries.
I am using Get file(properties only).
When I write a Filter Query with a typed date, then the query works. e.g "Last_x0020_Review_x0020_Date lt datetime'2018-10-05T23:17:12Z'"
When I do either of the following I am getting errors:
Filter Query: "Last_x0020_Review_x0020_Date lt datetime'@utcnow()'"
Error "The $filter expression ""Last_x0020_Review_x0020_Date lt datetime'@utcnow()'" is not valid.
clientRequestId:
serviceRequestId:
Filter Query: "Last_x0020_Review_x0020_Date lt datetime'{ }Output'" where { }Output is a Compose @utcnow()
Error: The $filter expression ""Last_x0020_Review_x0020_Date lt datetime'@utcnow()'" is not valid.
clientRequestId:
serviceRequestId:
Appreciate your feedback. Regards Angela
