Trying Finding the Root Cause for - The API 'sharepointonline' returned an invalid response for workflow operation 'When_an_item_is_created' of type 'OpenApiConnection'.

[VijayTailor]

Hi Flow Experts,

I have a flow that will be trigger on "Create of New item in SharePoint  List"

Error - The API 'sharepointonline' returned an invalid response for workflow operation 'When_an_item_is_created' of type 'OpenApiConnection'. Error details: 'The API operation 'GetOnNewItems' is missing required property 'body/value/0/Title'.'

Please provide your valuable suggestion.

Thanks in advance/

[rohsh354 · Accepted solution]

Hello,

It looks like you created the flow from the template. As a workaround, please try creating it from blank and verify if you get the same error message.

I have seen some similar scenarios, wherein sometimes the pre-defined templates does not render as expected.

[Anonymous]

Hi

I have the same problem:

The API 'sharepointonline' returned an invalid response for workflow operation 'When_a_file_is_created_(properties_only)' of type 'OpenApiConnection'. Error details: 'The API operation 'GetOnNewFileItems' is missing required property 'body/value/0/Description'.'

This is created from a blank template. Description is not a require field.

The workflow initially worked now it fails at the very start.

[Anonymous]

Hi

I found that deleting the initial trigger - When a file is created (properties) and then recreating it worked.

I then had to update all the variable in the rest of the flow  - a bit of a pain. 

I believe this a bug. 

Hopefully this works for you and Microsoft can look into this problem.

[shaikha92]

I'm having the same issue and tried deleting the flow and creating it again from template/blank but its the same result everytime. Anyone managed to fix this?

I'm trying to copy sharepoint on prem list item data when a record is entered to sharepoint online list. The workflow fails and doesnt start though it used to be working before. any thoughts on this?

[Heimdallr]

Same problem!

[mtiscia]

I have seen this error when the list items title value is blank or null. When setting a value, the error goes away. 

[dchan1]

This is exactly what happens to me. 

I was trying to update a SP list.  But, the SP List happens to have some blank entries on the Title column.  As we know, each SP List has a Title Column, and it can be renamed.  

Exactly like @mtiscia said, putting some values to this field make this error goes away. 

dchan1

[007James_Bond]

Thanks ..this approach works

[Ry2jericho]

I found that if you change column format in your list after you already created a flow, it can cause this. To solve I had to delete the action from the flow and put back in again.

[tekfu]

Not working, I try everything what I find in this forum

[shaikha92]

check the in SP List Title Column, it shouldn't be empty

[tekfu]

At my situation is SP library, but should I set default value ?

[shaikha92]

Yes. Make sure you set a default value and the value applies to all items.

[Anonymous]

I tried removing Pagination from get list item and it works fine

but I need 1000 records to be fetched and I cannot remove pagination how do I overcome  both.

[shaikha92]

I think there's limitation 10,000 records to be fetched. You can set it in the Action setting.

Switch on Pagination and add the number in the threshold. 

[Anonymous]

Hi @shaikha92 ,

Actually when I try to set pagination with limit the following error occurs, But if pagination is removed it works fine.

[shaikha92]

make sure the Title field is not empty

[Anonymous]

Could u pls help me since there is no Title field in Get Items

[shaikha92]

It might have been renamed. Check the columns setting one by one and examine the URL. usually the original column name will appear in the url. e.g. layouts/15/FldEdit.aspx?List=%7B5E4E90C6-FBD7-4BEA-8B60-9006D6860B00%7D&Field=Title