cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
YamiteKudasai
Helper IV
Helper IV

CREATE TABLE FROM EXCEL DATA ROWS

Hello Everyone

Good day! 


I have an excel file in SharePoint and I would like to seek your help regarding: 

- Is there anyway I can create table from excel data which is in rows. Which means the excel data value does was not in table format.

 

Is there any way to do this? Thanks in advance for your help.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User
Dual Super User

There is an action that will let you create a table in an existing Excel Spreadsheet based on a range of cells you provide.  You can also name the table and specify the column header names.

 

Pstork1_0-1652890327317.png

 



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

3 REPLIES 3
Pstork1
Dual Super User
Dual Super User

There is an action that will let you create a table in an existing Excel Spreadsheet based on a range of cells you provide.  You can also name the table and specify the column header names.

 

Pstork1_0-1652890327317.png

 



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Hi @Pstork1 , 

I have tried this one. The Range I set did set is $A1:$G7 but what if the $G7 is dynamic? how to do that?

If you are asking is there a way to make the table adjust based on how many rows are in the spreadsheet, then the answer is no there isn't.  What I've always had to do was create the table larger than I expect it to ever be. and then filter out empty rows when I use the table later.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (2,875)