cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Highlighted
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



@

Highlighted
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

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

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

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
Users online (4,737)