You’re offline. This is a read only version of the page.
Announcements
5
Hi all,
In a power automate flow, I am currently trying to enter json data (successfully parsed in power automate flow) into a newly created excel file that was copied template file.
The template is an excel file, with an empty table that looks like this:
However, when I try to copy this template file and insert data into it, I get an error, and it won't allow me to create the mapping of the json data to the desired columns.
Hi , @choraN
The "Add a row into a tabel" -Row property need this format Data:
[{Description:"xxx","Answer":"xxx",......},{Description:"xxx","Answer":"xxx",......},{Description:"xxx","Answer":"xxx",......}]
But the "Get file content" action is return the base64 file content instead of the json.
So if you want to copy the excel table to another excel table , you need to use the "List row present in a table" action to get the json content in stead of the "Get file content" action.
If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!
Best Regards,
Yueyun Zhang
Share
Report
All responses (
Answers (
