Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Flow brings a date earlier to the one selected in SP list

(0) ShareShare
ReportReport
Posted on by 509

Afternoon

 

I have a holiday approval flow running. It fires when a user selects a date in a SP list. The approval works fine but when the data comes through the day before is showing, so when an Outlook event is created it's the wrong date. Is there a regional date setting in Power Automate I can check, or has anyone encountered this before? 

 

Thanks in advance.

  • Hardesh15 Profile Picture
    Hardesh15 7,087 on at
    Re: Flow brings a date earlier to the one selected in SP list

    @darrenfloyd666 

     

    You Can also use Convert time zone action instead of expression.

    Annotation 2020-07-23 211711.jpg

     

    please Share your convert time zone expression. Correct way to use it in expression-

    convertTimeZone(utcnow(),'UTC','India Standard Time','dd/MM/yyyy')

     

    Thanks

    Hardesh

  • sutekh Profile Picture
    sutekh 509 on at
    Re: Flow brings a date earlier to the one selected in SP list

    @Hardesh15 

     

    I'm getting the following error: Unable to process template language expressions for action 'Convert_time_zone_2' at line '1' and column '35910': 'The template language function 'converttimezone' expects its fourth parameter to be a string that contains a date time format. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#ConvertTimeZone for usage details.'.

  • sutekh Profile Picture
    sutekh 509 on at
    Re: Flow brings a date earlier to the one selected in SP list

    Thanks @Hardesh15 I'll try it out and check back in

  • Hardesh15 Profile Picture
    Hardesh15 7,087 on at
    Re: Flow brings a date earlier to the one selected in SP list

    @darrenfloyd666 

     

    Select Source time : Coordinated Universal Time

     

    Then check if it solves your problem.

     

    Thanks

    Hardesh

  • sutekh Profile Picture
    sutekh 509 on at
    Re: Flow brings a date earlier to the one selected in SP list

    Thanks @Hardesh15

     

    The SP site is set to London UTC as is Outlook, so I'm a little confused as to what and how I convert the dates to. I've configured the action as below but I'm not sure of it.

     TimeZone.png

  • Hardesh15 Profile Picture
    Hardesh15 7,087 on at
    Re: Flow brings a date earlier to the one selected in SP list

    @darrenfloyd666 

    Two things-

    1. SharePoint site regional settings.

    2. Flow uses UTC time zone. it is advised that use convert time zone action or function in expression.

     

    Thanks

    Hardesh

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,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard