web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows Date conversion is ret...

Power Automate - Building Flows

Unanswered

Date conversion is returning a worng value.

(0) Share

Report

Report

Posted on by Kathryn_S

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.

Thanks 🙂

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

v-bacao-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 655 Super User 2025 Season 2

#2

Tomac 371 Moderator

#3

chiaraalina 276

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans