CODEWITHSUNDEEP
power-automatepower-automate-desktop
Satish
Satish

Reputation: 41

How to Change Date Format in Power Automate

I've tried pulling outlook emails in an excel table via power automate. All the details are getting pulled in respective columns; however date & time is getting pulled in different format i.e. 27-07-2022T12:40:11+00:00. May I know how can I get it in certain format i.e. dd-mmm-yyyy at hh:mm:ss IST? Below is the power automate process flow.

enter image description here

Upvotes: 0

Views: 861

Answers (1)

zeitgeistcode
zeitgeistcode

Reputation: 11

If your date is UTC, you can use the convertFromUtc function to do the conversion. Use 'India Standard Time' for IST as 2nd parameter and as 3rd parameter add the needed format.

convertFromUtc(utcNow(),'India Standard Time','dd-MMM-yyyy')

In case your date is not UTC. use the convertTimeZone function.

Alternatively there is also a convert time zone action.

Upvotes: 1

Related Questions