
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 🙂
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