I have an automation that sends my Microsoft Form responses into a SharePoint list.
Then, I have an automatic flow that sends these newly created SharePoint list items into Planner tasks.
A really important aspect of this all is the Due Date. In the form, I choose the Due Date (let's say it is 5/23). Then, this date appears correct in SharePoint (5/23) but comes up in my Planner task as (5/22). It is always one day early.
Can someone please recommend anything to help?
Solved! Go to Solution.
Hi @jwenzChubb ,
This is the know issue with SharePoint.
You need to add 1 day to get the correct date and time.
addDays(timestamp: string, days: integer, format?: string)
Expression to add 1 day to your current date time value.
This will solve your issue.
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Hi @vivekpande18 ,
Thanks for the quick response!
I am still having trouble.
How do I add 1 day to this?
This is currently how I am entering the Due Date Time:
Hi @jwenzChubb ,
Take a compose action inside that you add this expression for adding 1 day.
That compose output you can provide inside your planner.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!