Forum Discussion

Aykut's avatar
Aykut
Copper Contributor
Apr 15, 2025

Copilot Studio - Access SharePoint List

Hi There,


for a testing prupose, I want to create an agent with Copilot Studio.

I want to access SharePoint List via action="Get items" from SharePoint.

I selected/entered in "Inputs" section:

Site Address = http:// ....
List Name = Employee List 
Top Count = 5000
Filter Query = Dynamically


The list has employee information, around 10 columns, and 150 rows.

When I submit such "Who is Jasmin?" or any other similar question such "Who is Jasmin Tailor?"
Overall: I am searching about existing employee and not existisng in the list, ...

I get always this error message:

Error Message: The connector 'SharePoint' returned an HTTP error with code 400.

Error Code: ConnectorRequestFailure

Conversation Id: 3c0377a0-83c1-412b-9d1a-761f8202203a

Time (UTC): 2025-04-15T16:49:08.414Z

First time I run this agent with this action, I was asked to connect, which worked fine.
However I still get this error message. I am the creator of the agent and I am also the owner of this sharepoint list.


Any idea, what am I doing wrong?

Or can I somewhere check if this "Get  itrems" action or other actions are temporarily not working?


THANKS !
Regards,
Aykut

3 Replies

  • EmilianoAlberti's avatar
    EmilianoAlberti
    Copper Contributor

    I am also facing the same issues for the past 2 days - it used to work fine last week. I'm raising a support case to understand if there's an outage with the connector integration.

    • EmilianoAlberti's avatar
      EmilianoAlberti
      Copper Contributor

      Just a quick update, I figured out that the problem in my case was the columns of the SharePoint list - CP Studio was expecting all columns to be of 'string' type, I had to change all of them, and it worked. It's not the most elegant solution but it works.

      • Aykut's avatar
        Aykut
        Copper Contributor

        Thank you Emiliano, in future I will pay attention on the data type.
        However all fields in my SharePoint List are "Single line of text", so it is "string" type.

Resources