Setting variable to time and date seem incorrect

(0) Share

Report

Posted on by gcizman2024

240

Hi Team

I have this variable for both date and time, date is correct in terms of format. but what i notice, im in SA local time now is 13:49pm, but its behind 11:49am i am using this variable format on power flow to trigger email, but on the email is giving me that incorrect time. How can i change this but still using the variable?

formatDateTime( trigger()?['outputs']?['headers']?['x-ms-user-timestamp'],'yyyy/MM/dd HH:mm:ss')

Categories:

General Questions

All responses (2)

Answers (2)

Verified answer

gcizman2024 240 on at

Like (1)

Report

Re: Setting variable to time and date seem incorrect

@mmbr1606 splendid, the time is correct as well date thanks mate
Verified answer

mmbr1606 13,193 Super User 2025 Season 1 on at

Like (0)

Report
Re: Setting variable to time and date seem incorrect

hey @gcizman2024

can you try this please:

For your specific case, assuming the original timestamp is in UTC (you might need to adjust this if the source time zone is different), the expression would look like this:

formatDateTime(convertTimeZone(trigger()?['outputs']?['headers']?['x-ms-user-timestamp'], 'UTC', 'South Africa Standard Time'), 'yyyy/MM/dd HH:mm:ss')

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings