Planner completion date is null

[Adi1607]

My tasks are dependent on each other i.e. the completion date of a task will be start date of new task. But, the completion date is null, hence my flow fails. Can anybody help me with this issue?

Error message: Unable to process template language expressions in action 'Create_task_for_Accounting_-_Generate_Invoice' inputs at line '1' and column '2868': '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.'. 

[ScottShearer]

@Adi1607 

Can you post a screen shot of your Flow?  That will make it much easier for those who would like to assist.

[v-bacao-msft]

Hi @Adi1607 ,

Maybe you could use Filter array to exclude the tasks that the Completed time is null.

Best Regards,

[Adi1607]

Please see the above screenshot for your reference.

[Adi1607]

Hi 

I do not want to exclude the task since they are interdependent.

[v-bacao-msft · Accepted solution]

Hi @Adi1607 ,

If so, you need to use Condition to check if the completed time is empty. Configure Create task action in If yes/if no branch, if the completed time is empty, then Start Date Time in Create task action in IF yes branch The field is set to blank.

Because we could not fill null or '' in Start Date Time field. This is the workaround I can provide currently.

Best Regards,