Create and fill excel table

[Megs_beach]

I have a flow that creates a worksheet and a table. I need to add a section to fill the table with information from a SharePoint list. I have researched and tried several options with no success so far. 

the best option I’ve seen is to use JSON in the add a row function so that I can use dynamic content from the SP list. Others have reported this works fine for them. When I do it the inputs show the correct information, but I get an error on the output and the table won’t fill out (see the section below status: 400):

Does anyone know how to get around this error…or perhaps a better way to fill the table?

[v-liwei-msft]

Hi @Megs_beach 

Could you please show a screenshot of your flow?

I have made a test for your reference:

1.

2.

3.

4.

Best Regards,

Levi

[Megs_beach]

 

Here is a look at the flow. It looks almost identical to the test one you created. Initially I was creating the excel in a SP library, but I also tried doing it via OneDrive…neither works. I get the same error message no matter what. 

 

 when I run the flow it recognizes the dynamic content and shows it in the ‘input’ section of the add a row step, but then the ‘output’ section gives the error message shown in my original post and won’t actually fill the row with the information.

appreciate any ideas that may help!