Skip to content
Menu
SharePoint Gems
  • Power Platform
  • Development
    • SharePoint 2013
  • Migration
  • Administration
  • SP Online
  • Contact
  • About
    • Privacy Policy
SharePoint Gems

Solved: 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 ‘.

Posted on May 4, 2022May 4, 2022

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 ‘.’

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

Contents hide
1 Reason of the Error
1.1 Solution
1.1.1 Share this:
1.1.2 Like this:
1.1.3 Related

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.

  1. Go to SharePoint List settings
  2. Make “Title” column is optional/non- required field.

OR

  1. Go to your SharePoint list
  2. 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

Share this:

  • Print
  • Twitter
  • Facebook
  • LinkedIn
  • WhatsApp
  • Telegram
  • Pinterest
  • Reddit

Like this:

Like Loading...

Related

1 thought on “Solved: 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 ‘.”

  1. Clive Robinson says:
    October 10, 2023 at 7:39 PM

    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).

    Loading...
    Reply

Leave a ReplyCancel reply

  • Development
  • Migration
  • Poweer Apps
  • Power Automate
  • Power Platform
  • SharePoint 2013
  • SharePoint Administration
  • SharePoint Online
  • Tips
  • Uncategorized

Best of Computers

Blog Stats

  • 67,509 hits

Subscribe

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 1,433 other subscribers
Buy Me Coffee
©2025 SharePoint Gems | Powered by WordPress and Superb Themes!
%d