Showing results for 
Search instead for 
Did you mean: 
New Member

monthly copy sharepoint list


I wanna back up monthly a sharepoint list. Can i automate this with FLOW?

I tried to use trigger every 30days and then save the list to a Excel sheet... but i dont get it to work. 

Can Flow somehow create a sheet or a new document every month?

I need this data then to show it on a Power BI report.



Community Support
Community Support

Hi @frurofrunse,


This should be able to achieve using a flow like this:



You cannot use the SP items to create a document but you can insert rows with the corresponding columns.




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

Thanks for the information.

How does flow in this case enter the itmes like Age or Nationality?

Helpful resources

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (9,998)