Is it possible to generate an excel table from json data without add rows ?

[rssilvaba]

Hi all,

I had a flow that generates a csv table from json. all works well the issue is with MS excel trying to load the files and messing the encoding. which I believe there is not much we can do.

I wanted then to do the same but output an excel table and save the xls file into, either a document library or the user's onedrive. issue is that add rows is very slow and async.

Are there any alternatives to output an excel file from a Power Automate flow? just like we do with csv table?

Thank you all.

[v-litu-msft · Accepted solution]

Hi @rssilvaba,

It is impossible to generate an excel table from JSON data without add rows.

The only way could do is Create table, then use Apply to each and Add a row into a table action could do it, for example:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.