Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - General Discussion
Unanswered

Deleted list entry copied to excel

(0) ShareShare
ReportReport
Posted on by 2

Hi, 

New to the forum and power automate. 

having looked at all variations on the internet, i am drawing a blank. 

I have a list, with 5 columns

everyone uses this list to enter info but they also delete items too. 

 

i would like to create a flow when if anyone deletes an entry, the information deleted is populated into a spread sheet or at lease all the deleted info is sent to me via an email so it can be entered manually. 

 

Any help would be greatly appreciated. 

 

thanks in advance for your help. 

 

  • ScottShearer Profile Picture
    25,236 Most Valuable Professional on at
    Re: Deleted list entry copied to excel

    @Scottscott 

    Here's another idea....

    Create an alert on the list - configure the alert to fire when an item is deleted.  That will generate an email with the data from the list columns.  Create a Flow that fires when you receive a new email.  Configure the trigger so that it will not fire unless " has been deleted" is included in the email subject and the sender is no-reply@sharepointonline.com.  Since the email will be formatted, you can use a series of split() expressions to extract the column data.  On the other hand, you can just store the email body somewhere such as Excel.

    Here is an example of an alert email:

    image.png

     

  • Scottscott Profile Picture
    2 on at
    Re: Deleted list entry copied to excel

    hello,

     

    thanks for the alternative. 

    I will test this idea and let you know how that works.

    I am not too sure how this will go down with the user but i will get feed back. 

  • ScottShearer Profile Picture
    25,236 Most Valuable Professional on at
    Re: Deleted list entry copied to excel

    @Scottscott 

    The SharePoint When an item is deleted action does not give you access to the data (other than the ID and title) in that list item. 

    Consider this as an alternative solution:

    • Create a custom permission level that is the same as contribute without the ability to delete
    • Use the custom permission level with the list
    • Add a checkbox (boolean) to the list - call it "Delete this item" 
    • Create a Flow that, when the Delete this item box is checked
      • Copies the list data somewhere else
      • Deletes the item

     

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1