When we work with power automate, then sometimes we have a scenario, where we are facing error in Get_items action as “The API operation ‘GetItems’ is missing required property”. The full error looks like below.
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 ‘.’
Reason of the Error
The Title column of the list is required field, but contains the blank values.
We have provided a solution below.
- Go to SharePoint List settings
- Make “Title” column is optional/non- required field.
- Go to your SharePoint list
- Remove all items which has blank values.
This is a very simple solution to get rid of this error.