Answered

Date Time Error When Creating HTML Table

(3) Share

Report

Posted on by Beau Myrick

Hello,

My flow was working perfectly, and I haven't made any changes to it in 2 weeks. Upon running it yesterday it gave me an error where it didn't before when creating the HTML table to send. The error reads: The execution of template action 'Create_HTML_table' failed. The column values could not be evaluated: 'In function 'formatDateTime', the value provided for date time string '' was not valid. The datetime string must match ISO 8601 format.'. I also have another flow that runs the same data that is set up the same way that works fine. Has anyone else run into this problem or have a fix? I am using the expression: formatDateTime(item()['NextDueDate'], 'MMM d, yyyy')

Thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

trice602 16,164 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

The root cause here is for that row, the NEXTDUEDATE value is blank and why you cannot format it. Please go to that row or wherever your data is and review. Alternatively, you can use a quick if statement there, if equals empty true, use NA, else format your date expression.

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
Beau Myrick 14 on at

Like (1)

Report
Copy link

Link copied!

My NextDueDate column contains data so this can't be the cause.

Was this reply helpful? Yes No
Verified answer

trice602 16,164 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hi,

According to the screenshot you posted, that row's value is blank. Please review your error message. "...The string '' was not valid."

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
Beau Myrick 14 on at

Like (1)

Report
Copy link

Link copied!

There was an empty row at the very bottom of my excel sheet! Thank you very much!

Was this reply helpful? Yes No