cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HelplessMax
Helper I
Helper I

Flow-Sharepoint wrong time

I have created an approval flow that uses SharePoint as a trigger and data source (Sharepoint is set to our local timezone). 

 

During the approval process (6 approvers) I gather information such as the time and date when each approver has responded to the approval.

Here comes the problem: flow shows that Approver X has respondend at 15:06 o'clock.  Even in the "update sharepoint item" step it says 15:06.

In Sharepoint however seven hours get subsituted (to 08:06). For somer approvers one hours get added.

The same happens for the time the approval was made.

Here is the exact pattern:

Created Time: +1

Approver A:    +1

Approver B:    -7

Approver C:    -7

Approver 😧    +1

Approver E:    +1

Approver F:    -7

 

Any ideas ?? 😞 

Unbenannt1.PNG

 

Unbenannt2.PNG

 

Unbenannt3.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Gristy
Resident Rockstar
Resident Rockstar

just use utcNow() instead of the time from the flow action. Everything in SharePOint is stored in UTC anyway.

View solution in original post

3 REPLIES 3
Gristy
Resident Rockstar
Resident Rockstar

just use utcNow() instead of the time from the flow action. Everything in SharePOint is stored in UTC anyway.

View solution in original post

**bleep** dude, that seems to be working !

Thanks a lot 🙂 

sadly your advice just works in the steps where one hour got added, the -7 hour problem ist still existing 😞 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,723)