web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Date conversion is ret...
Power Automate
Unanswered

Date conversion is returning a worng value.

(0) ShareShare
ReportReport
Posted on by 4

 

Hi,

I have a condition in a flow where if a sharepoint library date equals todays date then send an email.

My issue is the date that is being retrieved from my SharePoint library is showing as the 20/12/2018 in the actual library by when i check the flow results i can see the date it has pulled through is the 19/12/2018 and i dont know why?

The 'Compose' exrpression is: formatDateTime(items('Apply_to_each')['Alert_x0020_Date'], 'dd-MM-yyyy') where 'Alert Date' is my SP Library Column name.

The 'Compose 2' expression is: utcNow('dd-MM-yyyy')

Below is a picture of the results and also of the SP library which clearly shows the Alert Date as 20/12/18.

 

Results.JPGFlow2-page-002.jpg

Thanks 🙂

 

Categories:
I have the same question (0)
  • v-bacao-msft Profile Picture
    on at
    Re: Date conversion is returning a worng value.

    Hi @Kathryn_S,

     

    It seems that you posted a similar question here, I agree with Alice's suggestion that the reason for the difference in the date display is the difference from the UTC time zone, you could try apply Alice’s recommendation to adapt your Flow.

    Please take a try and feel free let me know if issue still exist.

     

    Best Regards,

    Barry

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard