Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Issue trying to move data from one SharePoint list to another Error details: 'The API operation 'GetItems' is missing required property

(0) ShareShare
ReportReport
Posted on by 4

I've tried deleting and redoing the flow but every time I get this error. 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/10/Client'.'

 

We don't have a Client Column in the SharePoint list. We have a "Client Name" column, and I tried excluding it from the list view prior to testing the flow but still get the same error. 

  • Msantos0218 Profile Picture
    4 on at
    Re: Issue trying to move data from one SharePoint list to another Error details: 'The API operation 'GetItems' is missing required property

    I've tried deleting the flow multiple times and recreating it but still the same results 😞 I don't have any columns called "Client". If there was a column that was deleted before my time in the company, can I still use this list or is this list corrupted?

  • v-jefferni Profile Picture
    on at
    Re: Issue trying to move data from one SharePoint list to another Error details: 'The API operation 'GetItems' is missing required property

    Hi @Msantos0218 ,

     

    In case that you have a Client column which is required before but deleted later, you should delete the flow entirely and create it from blank:

    vjefferni_0-1706064180493.png

     

    Best regards,

  • Msantos0218 Profile Picture
    4 on at
    Re: Issue trying to move data from one SharePoint list to another Error details: 'The API operation 'GetItems' is missing required property

    Please help 😞

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1