Current DateTime and convert DateTime

[Moritz_Huber]

EDIT:

When i insert the correct conversion settings (according to my understanding) the source time should be 08:15

and the converted time shuold be 10:15

the times it really inserts into sharepoint list is utc = 21:17 and converted time 20:17

how the hack does that make sense? is it just twisted?

Why do i always get some kind of random datetime with the "Current time" and "Convert time zone" Actions?

For Example. The time at my location is actually 07:44 the time flow is writing into Sharepoint-List is 22:45 the day before. To my understanding the current time action should output the utc time which shuld be 0 and then my local timezone would be +1

This is very confusing. hope someone can clarify this

thank you in advance

[yashag2255]

Hi @Moritz_Huber 

The current time action returns the current time in the UTC time zone. Therefore, in the convert time action, you need to specify the source time zone as UTC:

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Moritz_Huber]

@yashag2255 

thank you for your reply. unfortunately there is no impact if i change the source time zone! i can set it to +1, +10, -5 the output is always the same and is not utc anyway.

second information if i change the output to +14 it is almost the time it needs to be but i can't got further. anyway this would be a very ugly hack.

why is the currentTime from Flows not the same as the utc time on google?

[yashag2255]

Hi @Moritz_Huber 

Can you try again? I just checked and it kinda works fine for me:

The get current time gets the UTC time and then the convert time converts it appropriately to my timezone..

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Moritz_Huber]

there the problem relies, i'll try to code it to the right way

[yashag2255]

Hi @Moritz_Huber 

So i can see that in your screenshot, you are getting the base time as UTC correct. There is an issue with source time zone though. Did you make the update to the source time zone ? It should be UTC as shown in my previous response. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Moritz_Huber]

How can i change that?

[yashag2255]

Hi @Moritz_Huber 

Please refer to the screenshot below:

---

@yashag2255 wrote:

Hi @Moritz_Huber 

The current time action returns the current time in the UTC time zone. Therefore, in the convert time action, you need to specify the source time zone as UTC:

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

---

In your flow, you need to alter the convert time action. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Moritz_Huber]

Actually the ms flow is doing it's work until it tries to update the sharepoint list element. the times in the flow-testrun are correct. if i have 11:14 in flows it updates the list object in sharepoint to 04:14.

why is that?

[yashag2255]

Hi @Moritz_Huber 

Can you check the regional settings of your SharePoint list? When date time is patched to a list, it converts the time to the specific timezone by itself. Please check if this has something to do with the SharePoint list time zone.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Moritz_Huber]

changed the language and the country-zone. However couldn't find the setting-link to see the current set timezone. Anyway this should work on company level not only on my local machine. what is best-practice for save date and times so everyone is talking about the same?

[yashag2255]

Hey @Moritz_Huber 

This goes like, suppose your current timezone is IST and the sharepoint timezone is set to UTC. When you submit a date/time based on current location, this will get converted to utc by default and gets saved to utc. If you apply some conversion over it, lets say convert this to utc before passing this as an input, this will apply the conversion twice, once based on your intervention, other by SharePoint.

This SharePoint side conversion is for the view purpose only, if you change the regional setting to current timezone, this will return the value whatever is posted by the user.

To set the regional setting, use the url: https://organizationname.sharepoint.com/sites/sitename/_layouts/15/regionalsetng.aspx

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!