cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JCast
New Member

How to Convert the TimeZone of Create Item Action for SharePoint

Hi!

 

I have a flow that get the csv attachment file sent thru shared mail box and put them in SharePoint List. There's an item/column header for submission date/time of request but, the output format in create item (SharePoint) action converts to UTC. How can I retain the original input? I already tried the convertTimeZone expression and got an error.

 

Input is came from output of Parse JSON

JCast_3-1643163887569.png

 

 

Results for Create Item for SharePoint

Input:

JCast_0-1643163549608.png

Output:

JCast_1-1643163608723.png

 

Actual Value in SharePoint List:

JCast_2-1643163700050.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
leyburn19
Memorable Member
Memorable Member

You need to put an expression in teh field.  Something like

 

addHours(utcNow(),??)  

 

Where the ?? add the hrs that match your zone.  Example my are is 10 hrs ahead of utc so I would put a 10

 

Replace utcNow with your Date Field as applicable

View solution in original post

2 REPLIES 2
leyburn19
Memorable Member
Memorable Member

You need to put an expression in teh field.  Something like

 

addHours(utcNow(),??)  

 

Where the ?? add the hrs that match your zone.  Example my are is 10 hrs ahead of utc so I would put a 10

 

Replace utcNow with your Date Field as applicable

v-xiaochen-msft
Community Support
Community Support

Hi @JCast ,

 

It looks like your region is 8 hours ahead of utc time.

As @leyburn19 's suggestion, you could use addhours function.

vxiaochenmsft_0-1643248682022.png

addHours(variables('var'),-10)
vxiaochenmsft_1-1643248747560.png

 

Best Regards,

Wearsky

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (1,583)