web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Use FormatDateTime and...

Power Automate

Answered

Use FormatDateTime and convertTimeZone function in the same expression

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

Attached is the flow that I created. The flow is emailing me the planner tasks with Creation and Completion Date.

The flow is working perfectly fine but it is not giving me the output in local time zone for Outage StartDate and Outage Completion Date columns.

I would like to keep the date format the way it is but need to convert it into Central Time Zone (US & Canada) which is my local time zone.

Is there a way I could club use convertTimeZone function with FormatDateTime function to achieve the output I need?

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

You could take a try with expression as below:

convertTimeZone('2018-01-01T08:00:00.0000000Z', 'UTC', 'Pacific Standard Time')

You could learn more of the workflow definition language with document below:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#convertTimeZone

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks @v-alzhan-msft

Was this reply helpful? Yes No

Join the conversation