Filter query in get items, select items where the date is less than one day

(0) Share

Report

Posted on by Palucci12

Hello,

I have get items like this

, and I would like it to show me only those records where today is one day greater than the date in the column.

"LastWorkingDateAction": "2023-08-03",
 "Modified": "2023-08-05T16:53:16Z",
 "Created": "2023-08-05T08:41:36Z",
 "Author": {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

but still getting an error:

The expression 2023-08-04 05:40:00 lt LastWorkingDateAction is invalid. Creating query failed.
clientRequestId: ab1fc3d1-bb5f-46b5-8df4-4a4216fd8a4e
serviceRequestId: ab1fc3d1-bb5f-46b5-8df4-4a4216fd8a4e

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

creativeopinion 10,506 Moderator on at

Like (0)

Report
Copy link

Link copied!

The order of your filter query is incorrect and the date needs to be in single quotes. The internal column name should be first.

It should look like this
Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉Watch my tutorials on YouTube
👉Tips and Tricks on TikTok

Was this reply helpful? Yes No
Palucci12 on at

Like (0)

Report
Copy link

Link copied!

Thanks for answer but another error shown ;
The query is invalid.
clientRequestId: 60810979-204d-4b6a-b750-70b7bce822e6
serviceRequestId: 60810979-204d-4b6a-b750-70b7bce822e6
{
"status": 400,
"message": "Kwerenda jest nieprawidłowa.\r\nclientRequestId: 0e556061-f115-4ede-b31b-8ba626b7fcb6\r\nserviceRequestId: 0e556061-f115-4ede-b31b-8ba626b7fcb6"
}

Was this reply helpful? Yes No
Verified answer

creativeopinion 10,506 Moderator on at

Like (1)

Report
Copy link

Link copied!

Please try the query while selecting a site and list name from the drop down menus, rather than using dynamic content.

Was this reply helpful? Yes No