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 🙂
