Deleted list entry copied to excel

(0) Share

Report

Posted on by Scottscott

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.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@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

Was this reply helpful? Yes No
Scottscott 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@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:

Was this reply helpful? Yes No