Answered

Daily Export from SharePoint List to Excel Online (Business)

(0) Share

Report

Posted on by draymond11

I'm trying to use Microsoft Flow to grab items in a SharePoint list and copy them into an Excel Online (Business) file every day.

I was able to copy items into an existing Excel Online (Business) sheet with a manually created Table using:

1. Schedule flow run

2. Get Items (filter query to grab items meeting the condition I want)

3. Add rows into Table

However, the items populate the bottom portion of the created Table. In other words, my created Excel table had 132 rows, but the Flow (correctly) returned 40 items and placed them at the bottom of the table (see attached).

Since the number of items returned each day will vary, how do I create a flow that creates a table then adds the appropriate number of rows based on the conditions I define?

Many thanks,

Drew

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

draymond11 20 on at

Like (0)

Report
Copy link

Link copied!

@draymond11 wrote:
I'm trying to use Microsoft Flow to grab items in a SharePoint list and copy them into an Excel Online (Business) file every day.

I was able to copy items into an existing Excel Online (Business) sheet with a manually created Table using:

1. Schedule flow run
2. Get Items (filter query to grab items meeting the condition I want)
3. Add rows into Table

However, the items populate the bottom portion of the created Table. In other words, my created Excel table had 132 rows, but the Flow (correctly) returned 40 items and placed them at the bottom of the table (see attached).

Since the number of items returned each day will vary, how do I create a flow that creates a table then adds the appropriate number of rows based on the conditions I define?

Many thanks,
Drew

@v-bacao-msft

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @draymond11 ,

You could delete all the rows in the table before add rows from the list to the table.

Please make sure the value of Key column would be unique in th excel table.

Please let me know if yourproblem could be solved.

Best regards,

Alice

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

Was this reply helpful? Yes No
PowerExplorer 65 on at

Like (0)

Report
Copy link

Link copied!

Hi Please I need help with similar issue, Except mine is weekly and not generating properly every time I test, at time it works next time it doesn't, I've posted it here,
https://powerusers.microsoft.com/t5/General-Power-Automate/Power-Automate-Excel-online-business-not-importing-adding-row

Was this reply helpful? Yes No
andreascarcelli 2 on at

Like (0)

Report
Copy link

Link copied!

I am trying to use the available template "Copy SharePoint list items to Excel Online Business and send an email" to have a live update on Excel of the new items in the MS Lists, but instead of adding only new items it adds continuously the same lines every each interval, without checking it if a line already exists, do you know how to solve it?
Thanks!

Was this reply helpful? Yes No