Unanswered

FLOW (Get Items) Filter SharePoint list on Date

(0) Share

Report

Posted on by Shash

I have question on the filter, the SharePoint list Filter Query I want to check if DueDate is greater than today, where DueDate is date column.

Categories:

Building flows

I have the same question (0)

All responses (21)

Answers (1)

Verified answer

v-xida-msft on at

Like (15)

Report
Hi @Shash,

Could you please share a screenshot of your flow's configuration?

Do you want to filter items of your SharePoint list with the OData query in Filter Query field of "Get items" action?

I have made a test on my side and please take a try with the following workaround:

Within Filter Query field of "Get items" action, type the following formula:

DueDate gt 'utcNow(...)'

The utcNow(...) is a WDL expression, which is wrapped with single quotes. Within right panel, select Expression tab, type the following formula:

utcNow('yyyy-MM-dd')

The flow works successfully as below:

In addition, on my side, the DueDate is a Date and Time type column and the Date and Time format is Date only:

If the Date and Time format of your DueDate column is Date & Time, please take a try with the following workaround:

More details about the WDL expression in Microsoft Flow, please check the following article:

https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

Best regards,

Kris

Was this reply helpful? Yes No
Shash 5 on at

Like (0)

Report

Thanks Kris, it worked.

Was this reply helpful? Yes No
RKushner 127 on at

Like (0)

Report

This isn't working for me. Is it possible that MS has broken another thing that used to work??

Here's my Filter Query and error message:

ExpiryDate le fx addDays(utcNow('yyyy-MM-dd'),10,'yyyy-MM-dd')

I know that addDays(utcNow... is working from the error:

The expression "ExpiryDate le 2018-06-22" is not valid. clientRequestId: 32c616f1-365e-4b8d-b0e7-1913c661f5b5 serviceRequestId: f766709e-8023-5000-d589-a40ee4e3f486

I have also reverified that ExpiryDate (the field name, not the label, but I have also tried with that, Expiry_x0020_Date) is a date with format Date Only.

Many thanks!!!

Was this reply helpful? Yes No
dsforman12 2 on at

Like (0)

Report

bump. also receiving the same error message.

{
  "status": 400,
  "message": "The expression \"Created gt 2018-08-01T08:54:02.0000000\" is not valid.\r\nclientRequestId: 61e52dea-2ef9-4aa5-af86-47351aa81dec\r\nserviceRequestId: 5f89809e-40cd-6000-0c69-c797a2814523"
}

Was this reply helpful? Yes No
Dawidvh 1,346 on at

Like (4)

Report

Hello

If you still get this error, please remember the single quotes around the expression.

Let me know if you don't come right.

Was this reply helpful? Yes No
KarlChristopher 55 on at

Like (0)

Report

Yep, I can agree that the dateTime format in sharepoint does not work and returns a 400 error code.

Was this reply helpful? Yes No
MiraGhaly 34 on at

Like (1)

Report

@KarlChristopher
Actually the problem will be in the field name so try to get all items and check the field name mine was End Date and realized it is ODATA_EndDate

Was this reply helpful? Yes No
gizmoburdine 16 on at

Like (7)

Report

So I spent a day beating my head against a wall on this. When using Flow ODATA filters you need to use sharepoint internal field names. I don't know exactly how these are created but when you have field names in sharepoint with spaces and other characters it will change the internal field name.
'Expiration Date' for me became 'Expiration_x0020_Date0'
to get this name I had to go to sharepoint and edit the column and then look at the url to get the internal field name
https://sharepoint.com/_layouts/.......................%7D&Field=Expiration_x0020_Date0

I hope this helps someone else

Was this reply helpful? Yes No
RobertPC77 59 on at

Like (0)

Report

I'm having trouble with the same thing... see my Flow below and feel free to provide help.

Was this reply helpful? Yes No
KarlChristopher 55 on at

Like (1)

Report

Hi you need to ' before and after the utcNow function

Was this reply helpful? Yes No