Answered

Convert date from Excel to string-date - Excel to Planner

(0) Share

Report

Posted on by TMX_Consult

I need to create a task in Planner by Power Automate using an Excel table, but an error message appears stating that the data type of the cell that has the task start date is in number format. I've made all the changes to Excel's date formats, but it always has the same error message.

Error: "OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of the 'Create_a_task' workflow operation of type 'OpenApiConnection' is not valid. Error Details: Input parameter 'body/startDateTime' must be of type 'String/date-time'. The runtime value '"44363"' to be converted does not have the expected format 'String/date-time'."

I've already changed to various date types in Excel and I've tried converting the timezone using Power Automate, but I still can't fix this error.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

mahoneypat 1,720 on at

Like (0)

Report

You can use an expression like this convert the date integer into a date. I hard-coded your integer below, but you can replace that part with your Excel value.

addDays('1899-12-30', 44363)

Pat

Was this reply helpful? Yes No
TMX_Consult 4 on at

Like (0)

Report

Obrigado por sua resposta rápida. É difícil encontrar pessoas que dão conselhos como esse. Estou tentando adicionar a função addDays, mas a 'Data de início' não aparece na área de conteúdo dinâmico, ou seja, não sei como poder aplicar o que você indicou. O conteúdo dinâmico está vazio.

Was this reply helpful? Yes No
Verified answer

mahoneypat 1,720 on at

Like (0)

Report

If the field doesn't show in the Dynamic Content, you can still reference it inside the Apply to Each with syntax like this in your addDays function.

addDays('1899-12-30', item()?['Date Field'])

Pat

Pat

Was this reply helpful? Yes No