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

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
Community Support Team
Community Support Team

Re: Daily Export from SharePoint List to Excel Online (Business)

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

2 REPLIES 2
draymond11
Level: Powered On

Re: Daily Export from SharePoint List to Excel Online (Business)


@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



@

Community Support Team
Community Support Team

Re: Daily Export from SharePoint List to Excel Online (Business)

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

Helpful resources

Announcements
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

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!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (10,478)