Skip to main content

Notifications

Power Automate - General Discussion
Answered

The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/OData__x0041_TT3' is required to be of type 'String/date'. The runtime value '"26/05/2023"' to be converted doesn't have the expected format 'String/date'.

(0) ShareShare
ReportReport
Posted on by 44

Hello , I hope someone could guide me in order to fix this issue.

 

I'm getting the start date from a Get Calendar View Event

 

    "start": "2023-05-26T13:00:00.0000000",
 
Also, Initialized a variable (DateWithoutFormat) type  string  to extract and save the date.
 
Sbassmed_0-1685075461223.pngSbassmed_1-1685075506132.png

 

 The expression value to extract  the day,month and year is the following:
 
formatDateTime(substring(items('Apply_to_each')['startWithTimeZone'],0,10),'dd-MM-yyyy')
 
Then I use  2 compose actions  with the following expression:
 
1. Action: DateWithoutFormat2 Value: The value is the variable DateWithoutFormat
2. Action: DateWithFormat  Value: formatDateTime(parseDateTime(outputs('DateWithoutFormat2'),'en-US'),'dd/MM/yyyy'
So that solve the ISO issue
 
Then in the "Create Item" Action, I've a field named "Date_MT", wich is a date field and the value is the Output from the compose DateWithFormat.
 
but when I´m creating an item into my Sharepoint list this error message appears:
 
"The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/OData__x0041_TT3' is required to be of type 'String/date'. The runtime value '"26/05/2023"' to be converted doesn't have the expected format 'String/date'."
 
I already checked the Date Field on my SharePoint list , but I don´t know what I´m missing .
 
If someone could help me I appreciate it.
 
 
 
  • jasonmcnear Profile Picture
    jasonmcnear 6 on at
    Re: The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/OData__x0041_TT3' is required to be of type 'String/date'. The runtime value '"26/05/2023"' to be converted doesn't have the expected format 'Strin

    Intended action:  Create new SharePoint List item when previous list item is marked completed, plus 'number' of days for next due date.  That works as expected, the issue is I format the due date in line with the desired result and still receive the error.

    I have added the following expression and I am still receiving the error.

    formatDatetime(outputs('ComposeDueDate'),'yyyy-MM-dd')

     

    The output from the above expression is 2023-07-28

    The input received in the following action is the exact same.

     

    Appreciate any asistance!

     

     

  • Verified answer
    Sbassmed Profile Picture
    Sbassmed 44 on at
    Re: The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/OData__x0041_TT3' is required to be of type 'String/date'. The runtime value '"26/05/2023"' to be converted doesn't have the expected format 'Strin

    Thank you. This work´s

  • Verified answer
    Re: The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/OData__x0041_TT3' is required to be of type 'String/date'. The runtime value '"26/05/2023"' to be converted doesn't have the expected format 'Strin

    Hi @Sbassmed ,

     

    Just compose date like this and add its output into your date time field:

     

    formatDateTime(item()?['start'],'yyyy-MM-dd')

     

    vwenjuanmsft_0-1685090710528.png

     

    Community Support Team _ Wenjuan Zou

    If this post helps, then please consider Accept it as the solution to help the other members find it.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard