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
Hi @Anonymous
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!
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?
Hi @Anonymous
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!
there the problem relies, i'll try to code it to the right way
Hi @Anonymous
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!
How can i change that?
Hi @Anonymous
Please refer to the screenshot below:
@yashag2255 wrote:
Hi @Anonymous
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!
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?
Hi @Anonymous
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?
Hey @Anonymous
User | Count |
---|---|
89 | |
40 | |
21 | |
20 | |
16 |
User | Count |
---|---|
137 | |
56 | |
46 | |
36 | |
26 |