Answered

Add a row to the Table Error

(3) Share

Report

Posted on by PR-25040755-0

Hello,

I am Passing Gallery items in JSON form to Power automate through power apps, I am creating file, table and Add a row to the table , in Row what data do i give?
When i do apply to each inside Add a row to the table i have given current item it is showing Bad request.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Suggested answer

rzaneti 4,491 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @PR-25040755-0,

You must pass a JSON object inside the Row input, where each key must match the name of the respective Excel column.

Check this example:

This is the output:

For referencing the individual properties for the currently iterated item in your Apply to each, you can use an expression. I'm also sharing some content for reference on how to work with objects and expressions in Power Automate:

- Object data type in Power Automate: https://digitalmill.net/2024/02/08/object-data-type-in-power-automate/

- Writing expressions in Power Automate: https://digitalmill.net/2024/02/27/writing-expressions-in-power-automate/

- Inserting and updating data into Excel Tables with Power Automate: https://digitalmill.net/2023/07/24/inserting-and-updating-data-into-excel-tables-with-power-automate/

Let me know if it works for you or if you need any additional help!

✅ If this solved your issue, please mark it as Accepted Answer.
👍 If it helped, feel free to give it a like!

🌐 Explore more Power Platform content on my Website or on my ▶️ YouTube
💼 Find me on LinkedIn

Was this reply helpful? Yes No
stampcoin 5,153 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@PR-25040755-0 Hi,

May I ask why you don't use Excel Online connector to add the row ? then you don't need that actually unless you use it in the flow for other task.

Enjoy Power Platform and have a great day 🚀 | My LinkedIn

If the answer helps, please consider 👍, Thanks.

Was this reply helpful? Yes No
PR-25040755-0 53 on at

Like (0)

Report
Copy link

Link copied!

HI, @stampcoin

i actually want to export the Gallery data on to a excel file and download the file when the user clicks on a button in Power Apps

Was this reply helpful? Yes No
PR-25040755-0 53 on at

Like (0)

Report
Copy link

Link copied!

Hi @rzaneti,

Since i am passing through JSON i have added like you said, but it is still showing me bad request.

Was this reply helpful? Yes No
stampcoin 5,153 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@PR-25040755-0 Hi,

I think use excel connector will be easy, and add Html text control to combine the url for the excel. done.😊

If you like power automate, I think @rzaneti can help.

Enjoy Power Platform and have a great day 🚀 | My LinkedIn

If the answer helps, please consider 👍, Thanks.

Was this reply helpful? Yes No
Verified answer

rzaneti 4,491 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @PR-25040755-0,

It looks like you have some special characters in some of the column names, such as dots:

When retrieving the column names with special characters to Power Automate, Excel encodes it in XML. So a table with a column name like this:

Will be read this way by Power Automate:

Then in your Add a rows present in a table action, you must follow the same pattern:

As a solution, I would recommend you to copy the keys of the JSON that you are inputting to Row and ask Copilot or ChatGPT to encode it to XML.

Let me know if it works for you or if you need any additional help!

Was this reply helpful? Yes No
PR-25040755-0 53 on at

Like (0)

Report
Copy link

Link copied!

@stampcoin,

I have a code where i have connected the excel table , and it is updating correctly.

The reason i shifted to Power automate was this app will be used by 19 departments where they can select the button , if i use download it is launching the file for me , not downloading the file.

Was this reply helpful? Yes No
stampcoin 5,153 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@PR-25040755-0 Hi,

Glad to hear you made it. 🍶 😊

There are many ways to make it, just choose the best for you.

Was this reply helpful? Yes No