cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cforbes14
Microsoft
Microsoft

Date from Forms changes in Planner when creating a new Task

I'm using Flow to get responses from my Form to then create a new task in Planner. One of the Form's questions involves a date. However, when they enter a date (4/21/21), it shows up in the Planner task as the day before the date submitted. (4/20/21). Is there a reason for this?

4 REPLIES 4
fchopo
Super User
Super User

Hi @cforbes14 

Could you try to apply the following expression in the Due Date Time column when creating the task in planner?:

concat(formatDateTime(body('Get_response_details')?['r2fb0a018c0e74c289b020fd1b6080993'],'O'),'Z')

Where r2fb0a018c0e74c289b020fd1b6080993 is the identifier of the date field in Forms.

Hope it helps!

Ferran

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

Hi @fchopo 

 

When I used the expression, it threw the following error: Unable to process template language expressions in action 'Create_a_task_' inputs at line '1' and column '22103': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'.

fchopo
Super User
Super User

Hello @cforbes14 

You have to replace r2fb0a018c0e74c289b020fd1b6080993 by your question field (the field where you are asking for the date). Is it informed?

Regards,

Ferran

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

Hi @fchopo ,

 

Yes I was able to replace r2fb0a018c0e74c289b020fd1b6080993 with the question field. However, the question field is already set to a date type and not a string, so that might be part of the problem?

 

 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,069)