Sharepoint Get items : 'The API operation 'GetItems' is missing required property 'body/value/8/Title'.'

[oddbjornolsen]

Getting this error message on a seemingly simple use of the "Get items" actions;

The API 'sharepointonline' returned an invalid response for workflow operation 'Get_items' of type 'OpenApiConnection'. Error details: 'The API operation 'GetItems' is missing required property 'body/value/8/Title'.'

Filter Query : <Tekstfield> eq null 

Using top Count : 10 (while testing)

[yashkamdar]

Hello Team,

Your Filter query is incorrectly configured in the GET ITEMS action.

Can you please let me know the type of the Column <Tekstfield> is , is it a Text or Date or Choice type column ?

Awaiting response...

[oddbjornolsen]

It is defined as Number. The intent of the flow is to use Update item further down in the flow to populate this field with a value based on an expression.

[yashkamdar]

Hello Team, This worked just fine for me and also returned the correct values for me, see below

I think the issue you are facing is that you are not correctly passing in the name of your column.

Can you copy the Internal name of your column and pass that in the query. 

You can find the name of the column in the List settings -> Columns -> Click on the column

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[oddbjornolsen]

Thank u for follow-up. The name is correct and to be on the safe side I now tried to remove the query and it still fails with the same error message.

As there is reference to Title in the error message I checked that it is there w/its standard field name and defined as required.

[Anonymous]

I had the same issue. Turns out I had a hidden column, that had been made mandatory, but which had no values it it. Once I took that off, the flow worked correctly.

[Anonymous]

Solved a similar issue by

1. changing the Title field to Optional (from Required),

2. then rebuilt the Get Items step in Power Automate.

Here's the error message I received to start this adventure:

The API 'sharepointonline' returned an invalid response for workflow operation 'Get_items' of type 'OpenApiConnection'. Error details: 'The API operation 'GetItems' is missing required property 'body/value/2/Title'.'

Hope this helps someone.

[harish1729]

This solved my issue. Thank you 🙂

[ManiLive]

Looks like Microsoft has fixed this issue with SharePoint - Get Items action.  I came across this issue recently with an old flow. 

When I created a new flow with the same action, the issue did not appear, even though I had a record with an empty Title value.

[JoshPayneSays]

Hello @oddbjornolsen , I am not sure if you have found a solution to your issue?

For the benefit of others who may be faced with a similar error (as I did).

As also mentioned by @Anonymous and others. This issue occurs when the source list/library contains BLANK fields that are either marked required or otherwise expecting a value. To resolve the issue either:

1) Remove the required fill option within your source list/library.

or

2) Alternatively, fill in the blank fields. You can quickly find the offending fields by going to the "Views > Items that need attention" menu option.

3) The red meta tag icon also highlights fields that need to be completed, as does the yellow highlighted "Required info" screen prompt.

In my case, I learned the hard way by deconstructing and reconstructing my Flow from scratch (not necessary by the way). 😫

Resolve the issue via the filling blanks within source List/ library

[Jānis]

How do you rebuild a step?

[Amapola188]

I am having exactly the same issue but:

a) it worked fine until about a week ago and there were no changes to the flow

b) the referenced Title column is not empty, all Title fields contain content.

c) There's no filter (I'm after the total item count for the list so filtering would defy the purpose)

Any other suggestions?

[dahianny29]

Thank you! This was SO helpful. 

[rpersad]

Hi @dahianny29 

Did u rebuilt the Get Items action to get it to work or did just changing the column required to false?