cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

The datetime string must match ISO 8601 format

Hello, 

 

I'm having issues with the following flow: 

When a new response is submitted in Microsoft Forms, create an event in Office 365 Outlook with start and end meeting time.

 

-> Basically the employee chooses in Forms the best date and time for a meeting

 

Capturar.PNG

-> But I'm struggling in Convert Time Zone in order to properly create the event in Outlook 

 

('Get_response_details')?['r74e3e959a1fc4db081e9bbe32280a111'] equals the date on Forms. 

 

Format string: 

formatDateTime(body('Get_response_details')?['r74e3e959a1fc4db081e9bbe32280a111'], 'dd/MM/yyyy HH:mm')

 

CTZ.PNG

-> After run i got the following error: 

 

Capturar.PNG

 

Thanks in advance! 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dual Super User II
Dual Super User II

Re: The datetime string must match ISO 8601 format

Is the date comming in from the Form as a string?  If it is then you may need to break it apart and rearrange it to the correct formatting to use it as a DateTime string.  If its a date already then you should be able to use DateTimeFormat.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

3 REPLIES 3
Highlighted
Dual Super User II
Dual Super User II

Re: The datetime string must match ISO 8601 format

ISO 8601 specifies that the date portion of a Date Time string is always formatted as yyyy-MM-dd.  Yours is formatted as dd/MM/yyyy.  Switch the order around and you should be fine.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Frequent Visitor

Re: The datetime string must match ISO 8601 format

@Pstork1I really appreciate your help.

 

However, I've switched the order to yyyy-MM-dd and I am still getting the same error.

 

Capturar.PNG

 

Capturar.PNG

 

The date: 15/10/2019 13:00 is from the selected date in Forms. 

 

Thanks in advance, 

 

Regards!

Highlighted
Dual Super User II
Dual Super User II

Re: The datetime string must match ISO 8601 format

Is the date comming in from the Form as a string?  If it is then you may need to break it apart and rearrange it to the correct formatting to use it as a DateTime string.  If its a date already then you should be able to use DateTimeFormat.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (5,331)