cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Filmbella
Level: Powered On

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
Filmbella
Level: Powered On

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.

2 REPLIES 2
Super User
Super User

Re: Create Excel table with unknown number of rows

@Filmbella 

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.

Filmbella
Level: Powered On

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.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

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

thirdImage

New Flow Community Board!

Check out the new Microsoft Flow Community Blog Topic Suggestion board!

fourthImage

Australia Summit

Travel to Melbourne and network with thousands of peers!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 255 members 4,005 guests
Please welcome our newest community members: