web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SharePoint Date and Ti...
Power Automate
Unanswered

SharePoint Date and Time column not working Power Automate

(0) ShareShare
ReportReport
Posted on by 77

Hi,

 

I have a SharePoint List with a date and time column. I want to draw the date and time out into an email using the expression ‘formatDateTime(item()?[‘body/Date’],’dddd, dd MMMM yyyy hh:mm tt’) However when I do get the date and time it’s off by a day or two. I have changed the site settings of SharePoint to 24 hours.

 

Thanks,

 

Gerard

Categories:
I have the same question (0)
  • Gerard2 Profile Picture
    77 on at

    Figured it out with Covert Time Zone.

    Replaced expression in Send an Email template with Covert Time Zone instead. 

  • Manish Solanki Profile Picture
    15,167 Moderator on at

    Hi @Gerard2 

     

    SharePoint stores the date & time field in UTC format, you need to convert to local time zone to get the correct date & time. Pls use the below expression:

    formatDateTime(convertFromUtc(item()?['body/Date'],'India Standard Time'),'dddd, dd MMMM yyyy hh:mm tt')

     here, am converting the value to IST (India Standard Time), pls refer to below link for all geo time zones values:

    Default Time Zones | Microsoft Learn

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

    Thanks

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard