Power Automate Planner Tasks from Forms & Sharepoint

(0) Share

Report

Posted on by jwenzChubb

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.

Categories:

General topics

All responses (6)

Answers (1)

Sort by

vivekpande18 894 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
jwenzChubb 32 on at

Like
a
(0)

Report
Copy link

Link copied!

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:
Thanks!
vivekpande18 894 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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 32 on at

Like
a
(0)

Report
Copy link

Link copied!

@vivekpande18 Unfortunately I am an amateur and do not fully understand
jwenzChubb 32 on at

Like
a
(0)

Report
Copy link

Link copied!

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

vivekpande18 894 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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