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

MS Flow creating Blank rows in Excel

Hi there,


I created a flow to update an excel spreadsheet from a Sharepoint List using the action "Add a row into a table"

Each time the flow runs, it adds 1 blank row.

 

How could I prevent these blank rows to pile up?

or how could I removed them? (the action Delete rows, does not seems to be working with blank data?)

 

FYI: I do not have blank lines in my sharepoint list, as each line must have an ID (column A)

 

Thanks


Sketch.png



 

 

 

 

 

 

Sketch2.png

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: MS Flow creating Blank rows in Excel

Hi @LoviseH ,

 

Ok, I have described it before, maybe different Excel files will have different results, so let you try do the same operation in new table.Smiley Happy

 

Maybe you have made some settings for the Excel file before.

 

Best Regards,

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

View solution in original post

6 REPLIES 6
Community Support Team
Community Support Team

Re: MS Flow creating Blank rows in Excel

Hi @LoviseH ,

 

Have you tried to create a new table and then do the same operation in the table to see if there is still the same problem?

I did a test on my side and there is no way to reproduce a similar error.

The number of times to execute Add a row into a table action is determined by the number of items obtained by Get items, and no additional insert operations are performed.

 

Or you could consider adding a key column to the Excel table using Add a row into a table action.

14.PNG

If the value of this key column is empty, Add a row into a table action will not be successful, which seems to avoid the problem of inserting blank lines.

Hope it helps.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
LoviseH
Level: Powered On

Re: MS Flow creating Blank rows in Excel

thank you @v-bacao-msft 
I will try that as soon as Sharepoint is back to life 😉
and will let you know the outcome
cheers

Jesse
Level: Powered On

Re: MS Flow creating Blank rows in Excel

 
LoviseH
Level: Powered On

Re: MS Flow creating Blank rows in Excel

hi @v-bacao-msft 

I narrowed down my problem
the intent of my flow is to refresh an excel spreadsheet using the data from a sharepoint list.
As I did not find any "update excel" container, I had first to use "delete a row" and then "add a row to a table"
the blank rows are in fact generated by the "delete a row" container. When all the rows are deleted, it just left the last one blank.
Do you have the same outcome?
thanks
@Jesse  FYI

 

Sketch.png

Highlighted
LoviseH
Level: Powered On

Re: MS Flow creating Blank rows in Excel

@v-bacao-msft 
well, I just created a similar flow using a different excel file, using the same sharepoint list:
no more blank row showing up anymore Smiley LOL
total mystery
@Jesse FYI

Community Support Team
Community Support Team

Re: MS Flow creating Blank rows in Excel

Hi @LoviseH ,

 

Ok, I have described it before, maybe different Excel files will have different results, so let you try do the same operation in new table.Smiley Happy

 

Maybe you have made some settings for the Excel file before.

 

Best Regards,

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

View solution in original post

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!

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!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

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 Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,592)