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 : efszQ8STKtEKE6tbrif3eA
Power Automate - Building Flows
Answered

Create Excel Table with Existing Excel Data

Like (0) ShareShare
ReportReport
Posted on 16 Jan 2020 03:55:14 by 35

Is there a way that I can convert an existing Excel worksheet with data that isn’t in a table format to a table formatted worksheet?

 

I receive an excel file that has a consistent number of rows, but may have varying numbers of columns.

The file is not formatted with any tables. I have a flow that saves the Excel file received as an attachment to a SharePoint location and am now looking to create a flow that reads the content of the file and updates a separate sharepoint list based on the content.

 

I’m stuck at how to convert the non-table formatted Excel file to one with a table within flow.

I know I can use “Create Table” but how would I determine the table size (I.e. the number of columns to specify in the table range)

 

Any suggestions would be greatly appreciated.

 

 

  • JohnAageAnderse Profile Picture
    1,986 on 16 Mar 2020 at 13:51:48
    Re: Create Excel Table with Existing Excel Data

    Hello

     

    Is there a known max number of columns?

    Are the columns always in the same sequence, no matter how many columns there are?

     

    Example:

    Excel file 1 has columns A, B, C, D, E, F, G, H, I , J , K, L, M, N, O

    Excel file 2 has columns A, B, C, D, E, F, G

    Excel file 3 has columns A, B, C, D, E, F, G, H, I, J, K

     

    Or are there a pattern to which columns are in each Excel file?

     

    Kind regards, John 

  • Verified answer
    v-alzhan-msft Profile Picture
    on 17 Jan 2020 at 01:27:56
    Re: Create Excel Table with Existing Excel Data

    Hi @Gunsmoke125 ,

     

    Sorry for there is no any way to determine the table size when format worksheet to table in Microsoft flow currently.

     

    Best regards,

    Alice       

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete