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 / List item shows correc...
Power Automate
Answered

List item shows correct time, but when referenced in flow, shows wrong time zone.

(0) ShareShare
ReportReport
Posted on by 29

I have a flow that takes data from a list in SharePoint (populated by a Canvas App form), and then populates a word template, then creates a Word.docx from that template using the date and time from the column in the list. It then does other stuff, but that doesn't apply to the issue I'm having.

 

The field in the Word template is just a Plain Text Content Control field:

 

kdub4049_5-1712767236741.png

 

You can see the appropriate portions of the flow below:

 

kdub4049_1-1712766152227.png

 

The list item shows the correct time local to us (-5 EST United States/Canada) as 10:35 AM:

 

kdub4049_2-1712766271198.png

 

When it does the file creation and appends the Date and Time field from the list into the filename, we get T14_35, four hours ahead:

kdub4049_3-1712766722593.png

And then the content of the document shows the Date and Time field incorrectly as well:

 

kdub4049_4-1712766929175.png

 

I'm not too worried about the filename as I'm just gonna delete it later anyway.  But the content of the file needs to show the time in the correct time zone.  I'll even take a workaround to get it to display correctly. 😄

Categories:
I have the same question (0)
  • Verified answer
    Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at

    Hi @kdub4049 

     

    This happens because the flow shows the time in UTC format of the time entered in the sharepoint list. To resolve that issue, you have to use expression around the Date & Time column while passing to the microsoft word do template.

     

    see the function below

    convertFromUtc(triggerOutputs()?['body/{{colname}}'],'India Standard Time')

     

    Here i am converting a column in SharePoint list from UTC to India Standard Time (IST) ,But you can convert it to any timezone depending upon your flow.

    Also replace {{colname}} with the name of parameter/column name u need to apply this timezone conversion 🙂

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • kdub4049 Profile Picture
    29 on at

    Sounds great!  I'm just not sure exactly where to put that expression.  Is it an action after the item is created?  Am I to put it in here?

    kdub4049_0-1712772831563.png

     

    Also, I'm guessing this is the expression I'm looking to put wherever it needs to be:

     

    convertFromUtc(triggerOutputs()?['body/Date and Time'],'Eastern Standard Time')

     

     

    Thanks for your help!

  • Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at

    Hi @kdub4049 

     

    correct, This expression is placed in correct place.

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • kdub4049 Profile Picture
    29 on at

    Yeah, I tried that and it didn't work.  I just gave up and did this:

    kdub4049_0-1712851320085.png

     

  • Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at

    Hi @kdub4049 

     

    may i know what you are getting ?

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • kdub4049 Profile Picture
    29 on at

    kdub4049_0-1712858993252.png

    kdub4049_2-1712859025695.png

     

    I'm guessing it's saying this because what is passed in is the date and time, so the time is not the first parameter.

     

  • Verified answer
    Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at

    Hi @kdub4049 

     

    I think column name used in expression is incorrect (sharepoint internal name may be differs what we see externally)

     

    since the expression looks like this

    convertFromUtc(triggerOutputs()?['body/Date and Time'],'Eastern Standard Time')

     

    could you pass the dynamic content for Date and Time column instead of writing this expression for the above bolded text.

     

    That would work !

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • kdub4049 Profile Picture
    29 on at

    Gotcha.  Yeah, it changed it by getting rid of the spaces in there, but it gave me a different error this time:

    kdub4049_0-1712859882443.png

     

    kdub4049_1-1712859914819.png

     

  • Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at

    Hi @kdub4049 

     

     timezone should be Eastern Standard Time not EasternStandard Time

     

    see below link for more details around timezones

    https://learn.microsoft.com/en-us/windows-hardware/manufacture/desktop/default-time-zones?view=windows-11

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • kdub4049 Profile Picture
    29 on at

    Oops....missed that.  Yeah, it's working correctly now, thank you!!

     

    kdub4049_1-1712861557031.png

     

    Now I just need to remove the "(UTC)" in the template. 🙂

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