web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Automatic copying of d...
Power Automate
Unanswered

Automatic copying of data from sharepoint lists to Excel - 1x a day and deleting existing data from sharepoint lists

(0) ShareShare
ReportReport
Posted on by 2

Hi,
I'm having trouble creating an automatic flow in Power Automate.
My sharepoint list is updated with new data every day. I want the data to be automatically copied from the SharePoint list to Excel every day, e.g. at night, and then deleted from the SharePoint list after such a task. Excel will serve as an archive.

 

Below is a screenshot of the SharePoint and Excel list with sample data

 

Pawel8_2-1701270243941.png

 

 

 

Pawel8_0-1701270006229.png

 

 

Do you have any idea?

Categories:
  • Anchov Profile Picture
    1,986 on at

    Take a look at the solution provided by Mathew Devaney. His example guides you through the scenario of copying a SharePoint list to Excel. You would just need to add a step at the end to delete the SharePoint list items.
    Quickly Add Multiple Rows to Excel Table In Power Automate (matthewdevaney.com)


    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.

    Cheers!
    Rick Hurt

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 377

#2
11manish Profile Picture

11manish 292 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 128

Last 30 days Overall leaderboard