web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How can I make a table...
Power Automate
Unanswered

How can I make a table include merged headers

(0) ShareShare
ReportReport
Posted on by
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.
 
  1. I uploaded an empty file with cells that look like the image I provided to SharePoint.
  2. I retrieved the uploaded file using the "Get file content" action.
  3. I created an identical .xlsx file using the "Create file" action.
  4. 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:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard