cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JCast
Regular Visitor

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 Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,319)