Skip to main content

Notifications

Community site session details

Community site session details

Session Id : WRUyYO97530duI/MU2hmpu
Copilot Studio - Topic Creation & Management
Suggested answer

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

Like (0) ShareShare
ReportReport
Posted on 3 Jan 2025 07:43:23 by 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:
  • MB-17011336-0 Profile Picture
    4 on 31 Jan 2025 at 14:26:54
    Issue in Update a row action of Excel in Co pilot studio
    Did you get this working? I can't!
  • Artur Stepniak Profile Picture
    1,521 Super User 2025 Season 1 on 03 Jan 2025 at 09:34:18
    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. Profile Picture
    167 on 03 Jan 2025 at 08:05:38
    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 Profile Picture
    1,521 Super User 2025 Season 1 on 03 Jan 2025 at 07:53:40
    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!

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Copilot Studio - Topic Creation & Management

#1
stampcoin Profile Picture

stampcoin 2

#1
Arild Aarnes Profile Picture

Arild Aarnes 2

Overall leaderboard

Featured topics

Loading started