Unanswered

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

(0) Share

Report

Posted on by DuaS.

187 Super User 2025 Season 2

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:

Topic creation & management

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Artur Stepniak 1,539 Super User 2025 Season 2 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
DuaS. 187 Super User 2025 Season 2 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Artur Stepniak 1,539 Super User 2025 Season 2 on at

Like (0)

Report

Okay, understood. But it seems that the input variable that you're using is malformed/not accepted by the endpoint.

Was this reply helpful? Yes No
MB-17011336-0 4 on at

Like (0)

Report

Did you get this working? I can't!

Was this reply helpful? Yes No