Forum Discussion
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
- EmilianoAlbertiCopper 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.
- EmilianoAlbertiCopper 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.
- AykutCopper 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.