cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AB21
Post Partisan
Post Partisan

Converted time is an hour out on Sharepoint list from a form

Hi all,

 

I am a bit confused on how to change my converted time submission stamp from a form in my Sharepoint list without it being an hour out! 

 

Current flow

 

Screenshot 2020-09-18 at 11.41.14 AM.png

 

Please help!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi again!

Not sure if this can explains the difference you experienced, but you get 1 hour difference depending on which Source Time you select (UTC vs GMT)

Flow_TZmistery.png

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

4 REPLIES 4
efialttes
Super User
Super User

Hi!

According to your screenshot, you added the same TimeZone as source and destination.

Can you share a print of the 'Submission time' received in the Forms response and confirm the time difference with your local time (I believe you wanna transfor it into your local time, right?)?

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Hi @efialttes ,

 

This is the out come 

  "submitDate""9/18/2020 10:22:48 AM",
 
which was an hour out at the time submitted. 
Is this what you wanted? 
 
SO I need it ot be British Summer Time (BST) not Greenwich Mean Time (GMT).

Hi again!

Not sure if this can explains the difference you experienced, but you get 1 hour difference depending on which Source Time you select (UTC vs GMT)

Flow_TZmistery.png

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Thank you! @efialttes 

 

This worked!

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.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

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.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (3,242)