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

[kdub4049]

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:

You can see the appropriate portions of the flow below:

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

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:

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

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. 😄

[Nived_Nambiar · Accepted solution]

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]

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?

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]

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]

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

[Nived_Nambiar]

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]

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.

[Nived_Nambiar · Accepted solution]

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]

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

[Nived_Nambiar]

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=windo...

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]

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

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