Hi Everyone
I have a flow that is pulling a LastModifiedOn column that is a DateTime in SQL on TABLE-A and updating another SQL table in the LastModifiedOn DateTime on TABLE-B.
Table-A DateTime is accurate as to when things happened, but when the flow runs to grab that datetime and put it in the other table it keeps adding 'Z' to the end and thus converting it to UTC. The time is 5 hours behind the time it's supposed to show. I tried to format doing these two methods and no change.:
formatDateTime(convertFromUtc(triggerOutputs()?['body/LastModifiedOn'], 'Eastern Standard Time'), 'yyyy-MM-ddTHH:mm:ss')
and I also tried this:
convertFromUtc(triggerOutputs()?['body/LastModifiedOn'], 'Eastern Standard Time')
Please help! When I run the flow it still shows 5 hours back with the Z at the end despite what the column from TABLE-A is showing.