MS Flow creating Blank rows in Excel

Like (0) Share

Report

Posted on 1 May 2019 00:21:00 by LoviseH

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

Categories:

Business Process Flows

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

v-bacao-msft on 06 May 2019 at 05:14:49

Like (1)

Report

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.

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

Best Regards,

Was this reply helpful? Yes No
LoviseH 16 on 06 May 2019 at 05:10:29

Like (1)

Report

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
total mystery
@Jesse FYI

Was this reply helpful? Yes No
LoviseH 16 on 06 May 2019 at 02:25:35

Like (0)

Report

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

Was this reply helpful? Yes No
Jesse 27 on 06 May 2019 at 02:11:59

Like (0)

Report

Re: MS Flow creating Blank rows in Excel

Was this reply helpful? Yes No
LoviseH 16 on 02 May 2019 at 21:07:34

Like (0)

Report

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

Was this reply helpful? Yes No
v-bacao-msft on 02 May 2019 at 09:01:43

Like (0)

Report

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.

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,

Was this reply helpful? Yes No