String/date-time error ( apps to automate)

[JoaoSantos489]

Hey guys.

So I have this Powerapps vacation app where the user chooses 4 periods of time to take vacation, then through a flow this data are inserted in a Sharepoint list and to a Sharepoint Calendar. And it´s in this last step where the error occurs.

Here is the work flow

(Lets focus only on the 1st period)

Here are the 2 variables (Start Date and End Date) (Portuguese speaker here :p)

The flow follows and these two dates are successfully inserted in the list.

Finally when I try to insert this event on the shared calendar...the flow fails

Traduction: The "inputs.parameters" of the "Create_item_2" workflow operation of type "OpenApiConnection" is not valid. Error details: The input parameter "item/EventDate" must be of type "String/date-time". The runtime value ""18/04/2022"" to be converted does not have the expected format "String/date-time".

Allready looked into several questions but none of them solved my problem.

Any help please?

Thanks in advance

[JoaoSantos489]

Here is the output in question.

[DamoBird365 · Accepted solution]

Hi @JoaoSantos489 

It's because the action expects an iso8601 date format.  The language translation in Power Automate has let you down to be honest, although it's not easy to understand.  

Your date needs to be in the format yyyy-MM-dd.  You can convert your datetime with parsedatetime.

E.g. parsedatetime('07-03-2022','en-gb')

Check out -> https://www.youtube.com/watch?v=ybPWtu1i1j0&t=37s

Please consider accepting my answer as a solution if it helps to solve your problem.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks

[JoaoSantos489]

Thanks! That worked perfectly @DamoBird365 .

And you just won a new subscriber. Congrats on the youtube channel! 

[Barking_Mad1]

Hi @DamoBird365 

I watched your clip but unfortunately couldn't get mine to work. It's a flow to check if a 'return date' is exactly 90 days from today's date. If it is, it sends an email. It was working, then bizarrely (but not unusually!) it stopped working.

My two expressions in the condition are:

• addDays(utcNow(),90,'dd-MMM-yy')
• formatDateTime(parsedatetime(outputs('Compose'),'en-gb'),'dd-MMM-yy')

Before your suggestion above the 2nd one was just:

• formatDateTime(outputs('Compose'),'dd-MMM-yy')

Any help appreciated!

[DamoBird365]

Hi @Barking_Mad1 

Try those two dates outside of a condition.  Create a compose for the first date and another for the 2nd, then create a compose with equals(compose1, compose2) and see if you get true.  Then when you do crack it, put it into a condition.  Excel has the ability to return datas as ISO8601 in advanced settings, check that out too.

Damien

[Schowd]

using parsedatetime('date','en-gb') worked for me, i was submitting data to Dataverse.
Power automate seems submits the data in the us format when adding a row, however it has another "row" which is the Display.V1.FormattedValue which was in the UK format (i thought this was what it wanted, when looking at the table in dataverse).  An idea maybe to create a record manually in your DataSource. List rows from that table/datasource and view how power automate is displaying the format of the date for that field.