Hello Everyone,
When building a flow, i'm having trouble with the date when adding a row into excel. I know i must convert the time zone to my location, but i can't run the flow with succes with this expression:
convertFromUtc(items('Herfstvakantie_toevoegen')?['Start'],'W. Europe Standard Time','dd-MM-yyyy')
When running the flow, i get the next error box:
"
Cannot process the template language expressions in the input for the Vakantie_toevoegen_aan_tabel on line 1 and in column 2875: For the template language function convertFromUtc, the first parameter is expected to be a string containing a UTC date / time. The value is 2020-01-08T00: 00: 00.0000000. Go to https://aka.ms/logicexpressions#ConvertFromUtc for usage information.
"
As you can see, the value is a date in UTC format.
Note: The "convert time zone" must be an expression and not an action. The expression is adding an row in Excel.
Al the expressions with the text "start" and "eind" are going to changed with the expression exaple above.
There is no room any more for more actions...
Thanks in advance 🙂
Hi @Anonymous
Try using Convert Time Zone action step
See below
Hi @abm ,
Thank you for your comment. Unfortunnaly your idea didn't solve the case. Got the same error result mentioned above.
Hi @Anonymous
Try the below.
convertFromUtc(string(items('Herfstvakantie_toevoegen')?['Start']),'W. Europe Standard Time','dd-MM-yyyy')
Thanks
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2