You’re offline. This is a read only version of the page.
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
Glad to hear it!
Not sure what happened - but just reran and looks like it has now succeeded - thanks for your help 😊
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
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:
Share
Report
All responses (
Answers (
@{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
could you provide a screenshot of that action block?
specifically, what is the value of "StartTime"?
thanks,
Kyle
#1
WarrenBelz
146,618
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,962
Most Valuable Professional
