cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jwenzChubb
Regular Visitor

Power Automate Planner Tasks from Forms & Sharepoint

Hello,

 

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?

 

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @jwenzChubb , 

Yes you can add this in to the due date box. 

 

You can follow the below vidoe to understand better. 

https://youtu.be/nwq56z1f0wI

 

Thanks

 

 

View solution in original post

6 REPLIES 6
vivekpande18
Solution Supplier
Solution Supplier

Hi @jwenzChubb , 

 

This is the know issue with SharePoint. 

You need to add 1 day to get the correct date and time. 

 

Use

addDays(timestamp: string, days: integer, format?: string)

Expression to add 1 day to your current date time value. 

 

This will solve your issue. 

 

Thanks

Vivek Pande

 

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: 

jwenzChubb_0-1652890125776.png

Thanks! 

vivekpande18
Solution Supplier
Solution Supplier

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. 

 

Thanks

jwenzChubb
Regular Visitor

@vivekpande18 Unfortunately I am an amateur and do not fully understand 

jwenzChubb
Regular Visitor

Can someone expand on this? Am I adding this into the Due Date box? An expression? 

Hi @jwenzChubb , 

Yes you can add this in to the due date box. 

 

You can follow the below vidoe to understand better. 

https://youtu.be/nwq56z1f0wI

 

Thanks

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (1,626)