Hello,
I have an xlsx template which contains one empty table with headers, it stored in a sharepoint folder. I use a power automate flow to add rows to this table and it is working fine, when I monitor the file I see the excell business add rows to table working:
I finish adding my rows and I get content of the template.xlsx file using the get file content sharepoint action:
Then I use this content in order to create a new file as follows:
There a bug in the get content action or in the create file, it always saves only the first row of the table into the new table. The template table contains 5 rows but the new table file_name.xlsx always gets only the first row of the table.... Very strange, I tried many workaround but seems like the file content is not correct:
Here is the format returned by the get file content:
{
"$content-type": "application/octet-stream",
"$content": "a lot of octe text"
}
it is not a JSON so I could'nt parse it or exploite it within the flow at any way, I only could used it as it is returned from the action.... Sadly the created file still gets only one row...
Can anyone help me with this I am really stuck with this problem it is been a while
Many thanks in advance!!!
