Hi,
I can't find the answer to the below question. I'm sure someone else will have already asked it but unable to find the solution.
I have a power automate flow where I have the below 2 connectors
Convert time zone
Update a row
The Convert time zone is converting a time from UTC to GMT where the time units are dd/MM/yyyy HH:mm:ss
In the update a row it is importing this converted time zone body into excel.
The flow is functioning with no errors
What is happening is that the date is entering into convert a time zone as 01/09/2024 00:00:00 (1 September 2024) and exiting in excel as 09/01/2024 00:00:00 (9 January 2024)
I'm not sure how it is doing this. Any help would be appreciated.