Answered

Convert time zone failed

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Experts,

I am new to the world of Power Automate/Flows and have been trying to edit an existing flow which looks to run fine until the 'Convert time zone' stage where I get the following error:

InvalidTemplate. Unable to process template language expressions for action 'Convert_time_zone_3' at line '1' and column '25969': 'In function 'converttimezone', the value provided for date time string '' was not valid. The datetime string must match ISO 8601 format.'.

This is what I have within convert time

Base Time: StartDate

Format String: Full date/time pattern (short time) - Monday, June 15, 2009 1:45 PM [f]

Source time zone: (UTC) Coordinated Universal Time

Destination time zone: (UTC+00:00) Dublin, Edinburgh, Lisbon, London

Does anyone have an idea why this error is occuring?

Thanks

Ramson

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

@ramaseko

could you provide a screenshot of that action block?

specifically, what is the value of "StartTime"?

thanks,
Kyle

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Thanks for your response Kyle ‌‌

Unfortunately it doesn't let me save an image on here.

The below is what I have in start date:
@{items('Apply_to_each')?['StartDate']}

Apply to each - is for each language variation where I am wanting to convert to local time - hope that makes sense?

Thanks
Ramaseko

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

@ramaseko

Can you go to the output of one of the failed runs and copy/paste the input value of "Start Date"?
It seems that the flow doesn't like the format of the date/time that you are passing in, and I am trying to determine what format that is currently.

Also, I'm not really understanding what the referenced "Apply to Each" loop is iterating through, can you be a little more specific? is it a table in a spreadsheet? A SharePoint list?

thanks,
Kyle

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Not sure what happened - but just reran and looks like it has now succeeded - thanks for your help 😊

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Glad to hear it!

Was this reply helpful? Yes No