Unanswered

Dynamic content from calendar event "starttime" not recognised as a valid

(0) Share

Report

Posted on by IW-14041728-0

I'm using the formula below in a flow to allow automated forwarding of calendar events

convertFromUtc('2026-04-17T20:00:00+00:00', 'UTC') [ I appreciate I am converting from UTC to UTC here but simply trying to debug]

convertFromUtc(triggerOutputs()?['body/start'],triggerOutputs()?['body/timeZone'])

with the string copied directly from dynamic content.

I'm getting the following error:

{"status":400,"message":"The string was not recognized as a valid DateTime. There is an unknown word starting at index 0.\r\nclientRequestId: 44aba0d2-86f3-4909-b34d-27f409572d5c","error":{"message":"The string was not recognized as a valid DateTime. There is an unknown word starting at index 0."},"source":"office365-we.azconn-we-003.p.azurewebsites.net"}

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

David_MA 14,404 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Your expression needs to be in this format convertFromUtc('2026-04-17T20:00:00Z', 'UTC')

Although, what you have would not be very useful as it converts UTC to UTC, which I think you know and are just using as an example. I think you want something like this convertFromUtc('2026-04-17T20:00:00Z', 'Eastern Standard Time')

You need to get your trigger output values to match this for the expression.

Was this reply helpful? Yes No
IW-01050915-0 3 on at

Like (0)

Report
Copy link

Link copied!

Thank you @David_MA . I'm sorry for the delay in responding to your helpful message.

I am still getting error* with the following troubleshooting script:

convertFromUtc('2026-04-17T20:00:00Z', 'Eastern Standard Time', 'yyyy-MM-ddTHH:mm:ss')

Here I have used the actual text that you provided prior to implementing it with trigger output.

*Action 'Update_event_(V4)' failed: The string was not recognized as a valid DateTime. There is an unknown word starting at index 0. clientRequestId: 7a4d36e3-a9ab-4a81-ad23-f18ff2aadd79

Was this reply helpful? Yes No
Expiscornovus 33,872 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @IW-14041728-0,

That start field returns the below format.
'2017-08-29T04:00:00.0000000'

Which is yyyy-MM-ddTHH:mm:ss.fffffff

https://learn.microsoft.com/en-us/connectors/office365/#graphcalendareventclientreceive

You can parse the date time with a parsedatetime function. That function will return a 8601 parsed datetime stamp which can be used in other date and time functions.

Below is an example with the start property

parseDateTime(triggerOutputs()?['body/start'], 'en-US', 'yyyy-MM-ddTHH:mm:ss.fffffff')

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
David_MA 14,404 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Have you resolved your issue yet? If so, please mark a response as answering it or update the post with what you did to resolve the issue. Otherwise, you may need to post a screen shot of your for saw we have a better understanding of what you are doing and the issue you are having. Based on the initial post, I assume your are doing something like this:

You are creating a calendar event, and then want to convert the start or end times from the create event to the time zone specified in the action. If so, the expression in my compose action is this:

convertTimeZone(outputs('Create_event_(V4)')?['body/start'], 'UTC', 'Eastern Standard Time', 'MM/dd/yyyy hh:mm tt')

When the flow runs, it returns:

If this isn't what you need, please share screen shots of what you're doing and explain what you are trying to accomplish.

Was this reply helpful? Yes No