Power Platform Community Forum Thread Details

Hello, I hope you can answer this question

So, I just want to make a table with merged headers like the image that i upload without using Power Automate Desktop.

Here's what i tried.

I uploaded an empty file with cells that look like the image I provided to SharePoint.
I retrieved the uploaded file using the "Get file content" action.
I created an identical .xlsx file using the "Create file" action.
I attempted to add rows to the newly created .xlsx file while maintaining the original cell structure.

This is where the first problem occurs:
I cannot write rows to Excel using any method other than "Add row into a table".

Secondly, After executing step 3, I create a table.

This is where another problem arises:
Because the headers are merged, I cannot create a table with merged headers using Power Automate.

What options do I have?

I want to create a table with merged headers and add rows beneath it.
Even if that's not possible, please let me know if there's a way to add rows sequentially without creating a table.

Thank you.

Categories:

Building flows