Problem with Sharepoint Flow and Time Zone

(0) Share

Report

Posted on by jonheb

164

Hey all,

I have a flow in which I create Sharepoint elements based on the latest element in a list.

Basically I start the list by putting in the first entry with start- and endtime and after that I start a flow where I put in a specific number x so that the flow creates x entries with the specific time and +7 days for start- and endtime, so that I get weekly entries with the same hours.

The flow works as expected but the problem is time zone differences when summer time ends. Based in germany at the end of october and in middle of march the time zone changes and the entries are wrong.

As a workaround I would now delete item 17 and all other wrong entries, change the item 16 manually to the correc time and restart the flow, then it works again.

My flow looks like this:

the addDays functions:

addDays(outputs('latest_ELEMENT')?['body/starttime'],7) (Anfangszeit)

addDays(outputs('latest_ELEMENT')?['body/endtime'],7) (Endzeit)

Does anybody have an idea how to fix this?

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

edgarsimoes Microsoft Employee on at

Like (0)

Report
Hello there, @vobius

In order to help you, I would like to recommend you to check this steps:
Go to Site Settings where your SharePoint list is hosted, and then click “Regional settings” which is under Site Administration, and you can change to your local region.

2. Consider use instead of the expressions, the "Date Time" connector.

Let me know if this actions can help you resolve this issue.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

Happy automating,

Edgar Simões

Was this reply helpful? Yes No
jonheb 164 on at

Like (1)

Report

Hey,
thanks for your input.
The regional settings are already correct as far as I'm aware.

I just tried using the Date time connector. It generates the same output unfortunately.

Was this reply helpful? Yes No
edgarsimoes Microsoft Employee on at

Like (0)

Report

Have you tried this connection action? If not please do so, and report how did it go.

Was this reply helpful? Yes No
jonheb 164 on at

Like (0)

Report

What should I use there? Convert from UTC+1 to UTC+1 ?

Was this reply helpful? Yes No
edgarsimoes Microsoft Employee on at

Like (0)

Report

Try to see with a compose action please, if the result with this connectors or your expressions gives you the right timestamp. So, that I understand if it is a power automate problem or a sharepont configuration.

Was this reply helpful? Yes No
jonheb 164 on at

Like (1)

Report

I just tried it:

The "Add to time"-Action always returns the same time.
The "Convert time zone"-Action (UTC+1 to UTC+1) returns the false time (the input time from Sharepoint is 1 hour off and therefore the output time is also)

Was this reply helpful? Yes No
edgarsimoes Microsoft Employee on at

Like (1)

Report

Well, you could create like a condition to check if the dates present in the row are inside the interval between end of october and in middle of march. If so, you could use the same formula and add +1h to write it right.

If a date is outside the interval that you have, you use the standard formula.

Tell me what your thoughts on this.

Happy automating,

Edgar Simões

Was this reply helpful? Yes No
jonheb 164 on at

Like (0)

Report

Would be a good idea, but I can't seem to find any expression to calculate whether or not the date is between october and march.

Was this reply helpful? Yes No