cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
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

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!

Top Solution Authors
Users online (6,705)