HELP - Trying to create a flow that will be triggered by deleting a row on a sharepoint list, and transferring that row into another list

[Madi916]

I am working on an asset database that is built on a Sharepoint list, and want items that are deleted on that list to be moved into another list that will work as a historical log for the database. Fairly new to Power Automate so unsure on how to do this.

[ScottShearer]

@Madi916 

I don't believe there are any "out of the box" Power Automate actions that meet your requirements.  While Power Automate does have a When an item is deleted trigger, it does not give you access to the data that was deleted. If your requirement can be met, it will via a custom connector/trigger.  I did a quick check and I don't see any third party connectors either but I did not do an exhaustive search.

[Madi916]

@ScottShearer Thanks for the help Scott. Do you think maybe another way to trigger the transfer into another list would be a better solution? Like a transfer to historical log column with a Y/N entry triggering the transfer?

[ScottShearer]

@Madi916 

While this is not an elegant solution and it does have downsides, here is an idea:

1. Create a custom permission level in SharePoint that does not allow for delete
2. Break inheritance and assign that permission level for users in your list
3. As you suggested, add a check box to the list titled Delete
4. Add a Flow that copies and deletes the list item when the box is checked

It is important to create a new permission level otherwise your users will just continue to delete.

NOTE: an SCA will still be able to delete items

[Madi916]

Would you happen to have an example of a flow that would be triggered by a checking the box, copying the row, transfer to list B, and delete from list A?

[v-xiaochen-msft]

Hi @Madi916 ,

Just provide an idea. I didn't test for it yet .

Maybe you can call rest api to get the latest deleted item. Because when an item is deleted, it will be stored in the recycle bin.

So I think you could do this:

1\ When an item is deleted trigger

2\ Check whether the item was deleted by user or flow (This is important . If you don't check this ,flow may result in an infinite trigger loop.)

3\ Get the latest deleted item Id and use rest api restore It. 

4\ Copy it to another list 

5\ Delete this Item in source list by using flow

Api for you reference:

_api/web/RecycleBin 

api/web/recyclebin('<recycle bin item id>')

_api/web/recyclebin('<recycle bin item id>')/restore()

Best Regards,

Wearsky