Unanswered

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

(0) Share

Report

Posted on by 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.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Madi916 14 on at

Like (0)

Report
Copy link

Link copied!

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

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

Like (1)

Report
Copy link

Link copied!
@Madi916

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

Create a custom permission level in SharePoint that does not allow for delete

Break inheritance and assign that permission level for users in your list

As you suggested, add a check box to the list titled Delete

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

Was this reply helpful? Yes No
Madi916 14 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No