Hi everyone,
I’m having trouble with a Power Automate flow that transfers tasks from an Excel sheet to Microsoft Planner. Specifically, I’m encountering an issue with the dueDateTime field not being in the correct format. I’ve tried several methods to fix this, but nothing seems to work. Here’s a detailed explanation of my issue and what I’ve tried so far:
I’m using Power Automate to:
-
Read tasks from an Excel table (stored in OneDrive for Business).
-
Create corresponding tasks in Microsoft Planner.
The issue arises when trying to set the dueDateTime field in the "Create a task" action. Excel stores dates as serial numbers (e.g., 45772), but Planner requires dates in the ISO 8601 format (e.g., 2025-12-31T00:00:00Z).
The error I’m getting is:
Action 'Create_a_task' failed: The 'inputs.parameters' of workflow operation 'Create_a_task' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'body/dueDateTime' is required to be of type 'String/date-time'. The runtime value '"45772"' to be converted doesn't have the expected format 'String/date-time'.
-
Using the addDays Expression in a "Compose" Action:
-
I added a "Compose" action with the following expression to convert the Excel serial number to a date-time string:plaintextCopyaddDays('1899-12-30', int(items('Apply_to_each')?['DueDate']), 'yyyy-MM-ddTHH:mm:ssZ')
-
However, the flow still fails, and the error suggests that the raw expression is being passed instead of the evaluated result.
-
Manually Formatting Dates in Excel:
-
Using Dynamic Content Directly:
-
Checking Group ID and Plan ID:
-
Trigger: Manually trigger a flow.
-
Action 1: List rows present in a table (Excel).
-
Action 2: Apply to each (loop through each row).
-
Why is the "Compose" action not evaluating the addDays expression correctly?
-
Is there a better way to convert Excel serial numbers to ISO 8601 date-time strings in Power Automate?
-
Are there any additional steps or actions I need to include to ensure the date is formatted correctly?
Any guidance or suggestions would be greatly appreciated! Thank you in advance for your help.
Hi everyone,
I’m having trouble with a Power Automate flow that transfers tasks from an Excel sheet to Microsoft Planner. Specifically, I’m encountering an issue with the dueDateTime field not being in the correct format. I’ve tried several methods to fix this, but nothing seems to work. Here’s a detailed explanation of my issue and what I’ve tried so far:
I’m using Power Automate to:
-
Read tasks from an Excel table (stored in OneDrive for Business).
-
Create corresponding tasks in Microsoft Planner.
The issue arises when trying to set the dueDateTime field in the "Create a task" action. Excel stores dates as serial numbers (e.g., 45772), but Planner requires dates in the ISO 8601 format (e.g., 2025-12-31T00:00:00Z).
The error I’m getting is:
Hi everyone,
I’m having trouble with a Power Automate flow that transfers tasks from an Excel sheet to Microsoft Planner. Specifically, I’m encountering an issue with the dueDateTime field not being in the correct format. I’ve tried several methods to fix this, but nothing seems to work. Here’s a detailed explanation of my issue and what I’ve tried so far:
I’m using Power Automate to:
-
Read tasks from an Excel table (stored in OneDrive for Business).
-
Create corresponding tasks in Microsoft Planner.
The issue arises when trying to set the dueDateTime field in the "Create a task" action. Excel stores dates as serial numbers (e.g., 45772), but Planner requires dates in the ISO 8601 format (e.g., 2025-12-31T00:00:00Z).
The error I’m getting is:
Edit: Does anyone know how to transfer tasks from Excel to Planner
