cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JoaoSantos489
Helper II
Helper II

String/date-time error ( apps to automate)

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.

1.PNG

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)

2.PNG

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

3.PNG

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

4.PNG

5.PNG

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

1 ACCEPTED SOLUTION

Accepted Solutions

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

 

View solution in original post

5 REPLIES 5
JoaoSantos489
Helper II
Helper II

Here is the output in question.

6.PNG

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

 

Thanks! That worked perfectly @DamoBird365 .

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

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.

Barking_Mad1_2-1646744078456.png

 

 

 

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!

 

 

 

 

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (4,624)