cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Create Excel table with unknown number of rows

I am working on a FLOW that will take an Excel email attachment, convert the existing data to a table, then put those rows of data into a SharePoint list. The problem is in the Create Table action as I have to specify the rows and columns, although I know the number of columns the rows always vary. How do I create a table that only captures the rows containing data?

 

https://powerusers.microsoft.com/t5/General-Flow-Discussion/Create-a-table-in-Excel-for-only-rows-th...

 

The above post does not help - I tried using it but the actions are different now and it doesn't work.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Anonymous
Not applicable

Re: Create Excel table with unknown number of rows

I actually figured out the best work around is using a Filter Array after "List items present in table" so that I only utilize the rows with data for the remainder of my configuration.

View solution in original post

2 REPLIES 2
Super User
Super User

Re: Create Excel table with unknown number of rows

@Anonymous 

Hi there.  Shot in the dark: But could you use the Create Table to just create a shell and then the "add rows to a table" further down to add each of the rows from the email?

 

-Ed-

 

 

 

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Highlighted
Anonymous
Not applicable

Re: Create Excel table with unknown number of rows

I actually figured out the best work around is using a Filter Array after "List items present in table" so that I only utilize the rows with data for the remainder of my configuration.

View solution in original post

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (6,261)