Issue with “Row” Field in Excel Connector’s “Add a row” Activity

Like (1) Share

Report

Posted on 16 Jul 2024 19:56:16 by MOZa

Hi everybody,

I am using the Excel connector in Copilot Studio and specifying the activity “Add a row.” I have filled in the required fields, but the last field “Row” is causing an error. I have tried various formats for this field but still get the following error:

Error Message: The connector ‘Excel Online (Business)’ returned an HTTP error with code 400.
Error code: ConnectorRequestFailure
Conversation ID: 5b8
Time (UTC): 2024-07-16T19:05:50.269Z

I can assure you the connection is correct because if I fill in the “Row” field empty record (record type), a new empty row is created in Excel.

Could you please help me with the correct format for the “Row” field? I really appreciate your help.

Thanks in advance.

edf0d095-6da1-41e...

3b06bbf4-a3cc-4db...

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Michael E. Gernaey 47,225 Super User 2025 Season 2 on 10 Aug 2024 at 06:14:03

Like (0)

Report

Issue with “Row” Field in Excel Connector’s “Add a row” Activity

Hi

Does it have to be { } for a JSON record?

Was this reply helpful? Yes No