You’re offline. This is a read only version of the page.
Hi everyone
I have a cell "date" in a excel sheet which is in a date format, but on flow I have this error message when I format the date in dd-MM-yyyy: Unable to process template language expressions for action 'Condition_2' at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string '44683' was not valid. The datetime string must match ISO 8601 format.
Can someone give me some advice
Thank you
Excel stores dates as an integer. If you are using a List rows present in a table action make sure you select the DateTime format in the action to ISO 8601.
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
Hi,
If you're after converting the date then this might help you:
It can be found using this method:
Some screenshots of your flow and data output might help others assist you as it's not easy reading what you're trying to do or your steps. You can snip and paste directly into replies.
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (
