You’re offline. This is a read only version of the page.
Announcements
Hello,
I am new to using power automate and I am getting the following error when trying to create a task from Excel to MS Planner.
The 'inputs.parameters' of workflow operation 'Create_a_task' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'body/startDateTime' is required to be of type 'String/date-time'. The runtime value '"44252"' to be converted doesn't have the expected format 'String/date-time'.
I am currently in the UK date timezone. Not sure how the date conversion works. If someone can help that would be great.
Also, does anyone know how to add labels in excel so when the task has been created in Planner, it will show the labels in the tasks?
@Anonymous Excel stores dates as an integer, not as a date. You can convert it to a date by adding a Compose control in the Apply to each and in the expression tab add
Share
Report
All responses (
Answers (
10,323
