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.
Power Automate Interview Questions and Answers
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 ‘.’
Customize SharePoint list forms without PowerApps
Reason of the Error
The Title column of the list is required field, but contains the blank values.
Solution
We have provided a solution below.
- Go to SharePoint List settings
- Make “Title” column is optional/non- required field.
OR
- Go to your SharePoint list
- Remove all items which has blank values.
This is a very simple solution to get rid of this error.
How To Save Records In Multiple List Using Power Apps Patch() function
This solution does not work with the built in Calendar field EndDate – even if set to optional or hidden in SharePoint. Nor can you pre fill the field with a default value as with other fields. (The problem occurs when you drag a calendar entry from one date to another which causes the EndDate to be blanked out).