cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
draymond11
Frequent Visitor

Daily Export from SharePoint List to Excel Online (Business)

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

 


Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions

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.

 

1.png

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.

View solution in original post

3 REPLIES 3
draymond11
Frequent Visitor


@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

 


Capture.PNG



@

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.

 

1.png

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.

View solution in original post

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-...

 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,429)