Unanswered

SharePoint Date and Time column not working Power Automate

(0) Share

Report

Posted on by Gerard2

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:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Gerard2 77 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Manish Solanki 15,097 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No