Skip to main content

Notifications

Power Automate - General Discussion
Answered

Power automate flow filling a list in sharepoint

(0) ShareShare
ReportReport
Posted on by 22

Hi,

I have created a flow in power automate for vacation approval which begins in a Form and ends both in a calendar and a list in sharepoint. The problem is that the date ends up in the list in sharepoint one day before it realy is and I don't understand why. Every where else it is correctly.

Approvals:

JII_0-1660310653719.png

Calendar:

JII_1-1660310696715.png

list:

JII_2-1660310740660.png

 

 

  • JII Profile Picture
    JII 22 on at
    Re: Power automate flow filling a list in sharepoint

    Thanks! that was it.

  • Verified answer
    Re: Power automate flow filling a list in sharepoint

    Hi @JII ,

     

    The issue seems to be related to timezones. 

    SharePoint stores all its date/time fields in UTC time and then displays the corresponding local time based on the time zone in the Site setting. 

    SharePoint time, is not your time, is not their time. – Veni, Vidi, Vici (julieturner.net) 

     

    Maybe you could try to use the convertToUtc() function to convert the time zone. 

    convertToUtc('<timestamp>', '<sourceTimeZone>', '<format>'?) 

    https://docs.microsoft.com/en-us/windows-hardware/manufacture/desktop/default-time-zones?view=windows-11#time-zones 

    vyujincuimsft_0-1660638257870.png

    Result Screenshots: 

    vyujincuimsft_1-1660638257873.png

    vyujincuimsft_2-1660638257875.png

     

     

     

    Best Regards, 

    Charlie Choi 

  • JII Profile Picture
    JII 22 on at
    Re: Power automate flow filling a list in sharepoint

    And in the calendar the end date is wrong as well....

    I think it might be with times, but forms does not allow me to select date and time and I don't know how to correct that in power automate so that the list and calendar end up correctly.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard