Copilot Studio - Topic Creation & Management

Issue in Update a row action of Excel in Co pilot studio

Like (0) Share

Report

Posted on 3 Jan 2025 07:43:23 by DuaS.

167

I have made a agent that gets questions from an excel file located in sharepoint library name 'Test Library' with file name SOP Questions.

i have a get a row action of excel that is working fine and through ask a question action asking the first question from the excel. now i wanna store the reply to the column name 'Response'.

Error is .Error Message: The connector 'Excel Online (Business)' returned an HTTP error with code 400. Error Code: ConnectorRequestFailure Conversation Id: 85517ffb-b898-47a4-90b9-b117c709c89d Time (UTC): 2025-01-03T07:31:53.151Z

Categories:

General

All responses (4)

Answers (0)

MB-17011336-0 4 on 31 Jan 2025 at 14:26:54

Like (0)

Report

Issue in Update a row action of Excel in Co pilot studio

Did you get this working? I can't!
Artur Stepniak 1,526 Super User 2025 Season 1 on 03 Jan 2025 at 09:34:18

Like (0)

Report

Issue in Update a row action of Excel in Co pilot studio

Okay, understood. But it seems that the input variable that you're using is malformed/not accepted by the endpoint.
DuaS. 167 on 03 Jan 2025 at 08:05:38

Like (0)

Report

Issue in Update a row action of Excel in Co pilot studio

@Artur Stepniak response column initially is empty and then im populating the response column value with the variable name question1answer that is coming from "ask a question" action
Suggested answer

Artur Stepniak 1,526 Super User 2025 Season 1 on 03 Jan 2025 at 07:53:40

Like (0)

Report

Issue in Update a row action of Excel in Co pilot studio

Hello,

HTTP 400 error suggests that you're request is not properly formatted. Have you checked what's the input provided in the response column?

Overall, I'd really recommend you to not use an Excel sheet as a datasource, unless it's required. Excel connector has a lot of limitations enforced and in general it's not as stable as a SP list, for example.

In case of any other questions, let me know. If the answer helped you, mark it, so that others can benefit from it.

Best regards,

Artur Stepniak

Interested in GenAI? Visit my site!

Community site session details

Issue in Update a row action of Excel in Co pilot studio

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Leaderboard > Copilot Studio - Topic Creation & Management

Featured topics

Product updates

Community site session details

Issue in Update a row action of Excel in Co pilot studio

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Subscribe to this forum!

Select categories

Leaderboard > Copilot Studio - Topic Creation & Management

Featured topics

Product updates