Answered

Duedate null value error when using Powerautomate to add a Planner task with task descripton

(1) Share

Report

Posted on by SueZeeBee_ganto

I've built an app to show and also be able to add tasks to a certain Planner with PlannerId.

Because I couldn't add a new Planner task with a task description in one onsave button transaction in Powerapps, I've tried using Powerautomate.

The scripts runs fine when I put a date in the Duedate field in my powerapp.

However, the value for DueDate can also be null (I put the Default value for the DuedateCalendercontrol to Blank()).

This generates an error in Power Automate. Can anyone help me with the correct syntax/formula/solution for the function in PowerAutomate?

I've tried this formula in Powerautomate in the DueDate field based on a combination of posts I've read about this subject, but it gives an error when I test it.

If(empty(triggerBody()?['Createatask_DueDateTime'],null,formatDateTime(triggerBody()?['Createatask_DueDateTime'],'dd-mm-yyyy')

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

SueZeeBee_ganto 69 on at

Like (0)

Report
After some more investigation and exploration, I found out that the error occured in PowerApps and the Powerautomate process did not even run in case of an empty duedate. The error in Powerapps said the method run had an invalid value for parameter DueDate. So what I've done now:
made a Powerautomate flow with a create task with the field DueDate empty
made a Powerautomate flow with a create task with the field DueDate (ask Powerapps-variable)
added an Updatecontext function on the on change property from my calendar control for Due date to change to true
the onselect property of my save button runs the first Powerautomate script if the duedatevariable is false, the second Powerautomate is it is set to true
And it works!

Was this reply helpful? Yes No
Suggested answer

derb 30 on at

Like (0)

Report

Another way to manage this is in the powerautomate field that handlesthe dynamic action, use an expresion with if(empty(dynamic action,value, dynamic action) In this expression when you are writing it in the places "dynamic action", you toggle to the dynamic action tab to select the one you want. The "value" is the value you want defaulted if the field is null. This worked great when processing Microsoft Forms with fields that are not required.

Was this reply helpful? Yes No