Problems in formatting data coming from Email

[GiovanniM]

Hi,

I'm a complete beginner here, so please help with easy words 🙂

I've created a flow that once an email is received, trigger the creation of a task in Planner.

It works in its basic function

But now I'm trying to insert automatically the due date in the task as: Email received date + 7 days.

This is what I've tried to do:

adddays(triggerBody()?['DateTimeReceived'],7,'dd-mm-yyyy')

Unfortunately the "time received" arrives with a wrong format, as you can see below. I've also tried to add a "compose" step but cannot understans in which format the date arrives...

Compose: formatdatetime(triggerBody()?['DateTimeReceived'],'dd/mm/yyyy')

Thanks a lot for your help

What to do next?

[Ajinder31]

Hi @GiovanniM , Please try with captial MM in format. mm represents minutes of recevied Date time.

adddays(triggerBody()?['DateTimeReceived'],7,'dd-MM-yyyy')

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

[GiovanniM]

Thanks a lot! Almost solved, but still not able to insert it in the Task-Planner in the due date

[Ajinder31 · Accepted solution]

Hi @GiovanniM , Can you please give it a try without passing the format?

adddays(triggerBody()?['DateTimeReceived'],7)

OR 

adddays(triggerBody()?['DateTimeReceived'],7,'yyyy-MM-dd')

I haven't tried it on my side. Please let us know if it doesn't work.

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

[GiovanniM]

Great, it worked