Unanswered

Fail to change format of Start and Due Date in my flow under "Create a task in Planner"

(0) Share

Report

Posted on by Ansolysbeck

Hi,

I have built a succesful flow integrating a shared Outlook mailbox to a Planner in Teams. However, I struggle reformatting my Start and Due Date to dd-MM-yyyy.

I have tried formatting it directly by in the fields by: formatDateTime(utcNow(),'dd-MM-yyyy')

I have also tried initializing it as a variable above the 'Create a task in Planner' step.

None of this works, and I get the error message: "The 'inputs.parameters' of workflow operation 'Create_a_task_in_Planner' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'body/startDateTime' is required to be of type 'String/date-time'. The runtime value '"21-08-2022"' to be converted doesn't have the expected format 'String/date-time'."

I am really not sure what the problem is. Can anyone help me?

Thanks a lot!

Cheers,

Annasofie

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Hello @Ansolysbeck ,

have you already tried with the following?

string(formatDateTime(utcNow(),'dd-MM-yyyy'))

or

string(formatDateTime(utcNow(), 'MM-dd-yyyy'))

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

My blog site about Power Automate: https://powerautomatejoy.com/

BR,

Marco

Was this reply helpful? Yes No
Ansolysbeck 2 on at

Like (0)

Report

Hi @MarconettiMarco,
Thanks for your reply. I believe:
string(formatDateTime(utcNow(),'dd-MM-yyyy'))
is what I have done. The strange thing is that I managed to convert the date in the title using this method, but for the Start and Due Date is does not work.
When I do:
string(formatDateTime(utcNow(),'yyyy-MM-dd'))
it works (but would be the same as simply writing utcNow, and is not the format I want.

As seen in the below screenshot, the Start Date time appear correct in the
Do you have an idea of what the problem could be?
Thanks!

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Hello @Ansolysbeck ,

please try to change the Regional format settings:

https://www.adamfowlerit.com/2018/07/how-to-change-the-microsoft-planner-date-format/#:~:text=Under%20the%20General%20area%2C%20scroll,date%20format%20for%20Planner%20tabs.

I'm able to create the Task using the following expression to set the Start Date:

formatDateTime(utcNow(),'MM/dd/yyyy')

or simply:

utcNow()

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

My blog site about Power Automate: https://powerautomatejoy.com/

BR,

Marco

Was this reply helpful? Yes No