Answered

From Forms Date to Powerautomate Add 114 days to date to Planner task due date

(0) Share

Report

Posted on by zaddison

Hey community,

I want to take the date from Microsoft Forms using powerautomate add 114 days to it and put that as the due date in Planner for a task that is generated.

Example: Someone puts 1/1/2023 in the form. I want to add 114 days to that automatically and then take the new date and put that as the due date for the planner task that is created.

Here is one error I get. But I figure there is a better way to do it.

Unable to process template language expressions in action 'Format_90_Days' inputs at line '0' and column '0': '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.'.

Thanks!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Ellis Karim 11,944 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @zaddison ,

The issue is likely to be that the user did not enter a date into the form, and this your expression is trying to format an empty string (null value) to a Date Time format:

The provided value is of type 'Null'.

Please check the date in the forms response, and check the formatDateTime expression to ensure that it is recieving a valid date.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @zaddison,

Have you resolved your problem?

Actually, @ekarim2020 is right that your data source probably has null value in records. To solve this, you could skip these null values:

if(empty(<dynamicContentWithDate>), <ifConditionIsTrue>, <ifConditionIsFalse>)

You could format the date time in the branch of the ifConditionIsTrue.

Was this reply helpful? Yes No