The datetime string must match ISO 8601 format

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a sharepoint list which stores"Business Response Date" as a Date.

I have a flow which Gets Items and then a query filter of:

Status eq 'Approved' AND @{addDays('Business_x0020_Response_x0020_Date',180)} gt @{utcNow()}

I get the error: The datetime string must match ISO 8601 format

I have tried various things including adding a 3rd parameter to addDays of 'yyyy-mm-dd' but I'm struggling to figure out what's wrong.

Categories:

General topics

All responses (10)

Answers (1)

Sort by

DeepakS 2,301 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Try following expression:

Status eq 'Approved' AND

addDays(formatDateTime('Business_x0020_Response_x0020_Date','yyyy-MM-dd'),180,'yyyy-MM-dd')

gt

formatDateTime(utcNow(),'yyyy-MM-dd')

Regards,
DS
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @DeepakS

Thanks so much for replying.
I tried as you say and I now get:
"Unable to process template language expressions in action 'Get_items' inputs at line '1' and column '15867': 'In function 'formatDateTime', the value provided for date time string 'Business_x0020_Response_x0020_Date' was not valid. The datetime string must match ISO 8601 format.'."
DeepakS 2,301 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Can you add a compose action before and check what value you getting in Business_x0020_Response_x0020_Date column?

Regards,

DS
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Business_x0020_Response_x0020_Date output is 2019-12-12T12:01:00Z
DeepakS 2,301 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Is this column is empty for any item?

Regards,

DS
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

No, I only have the 1 item in the list at the moment for testing.
DeepakS 2,301 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Interesting, as the date format looks good. would you mind share the full screen capture of the Flow?

Regards,

DS
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Verified answer

DeepakS 2,301 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous

Use following expression :

Status eq 'Approved' and Business_x0020_Response_x0020_Date gt 'formatDateTime(addDays(utcNow(),-180),'yyyy-MM-dd')'

Regards,

DS
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Brilliant, thank you!
I did have to change Business_x0020_Response_x0020_Date to Business_x0020_Response_x0020_Da. I'm guessing there's a max name length I've hit. I also changed gt to lt.
Thanks again!