HI All
Error message prompted out - " In function 'formatDateTime', the value provided for date time string '44865' was not valid. The datetime string must match ISO 8601 format.'"
my designed flow as below (the data of 'Compose' is from the Microsoft Form and it is set for input as a date)
The flow failed to run as error message indicated that the datestring does not comply with ISO 8601.
can anyone advise how to change the date format in Number to ISO 8601 format
Hi Sundeep
Thanks for your quick response and my problem is resolved.😊
Hey @Problematic
You will have to format the date in a particular format. Check out the following links for help:
https://www.youtube.com/watch?v=uFZxXMuLj-E
https://www.shanebart.com/ms-flow-excel-dates/
https://powerusers.microsoft.com/t5/General-Power-Automate/Manipulating-Flow-Excel-Date/td-p/365876