Recreate deleted items

[jjcook]

Hi all, 

I have a workflow which creates an item in SharePoint list when an email is received to a shared mailbox. 

I need to remove the delete option in the list, which I have tried to do with permissions and it works for a couple of days and then the permissions stop working. 

To solve this, I would like to create a workflow to reverse the deletion of an item essentially. 

So when an item is deleted, get the item and recreate it in the list. 

So far I have a flow as follows: 

- When an item is deleted

- Get changes for an item or file (properties only)

- Send an HTTP request to SharePoint

- Compose

The flow fails at the second step, I assume because the item is deleted it can't find the item. 

Any help much appreciated!

[Expiscornovus]

Hi @jjcook,

The item will be in the recycle bin. You can find it with some filtering in the recycle bin. When you have found a match you can use its id to restore it again with the restore method.

Below is an example

1. URI to filter on LeafName and Title of the list item

_api/web/RecycleBin?$filter=startswith(LeafName,'@{triggerOutputs()?['body/ID']}') and Title eq '@{triggerOutputs()?['body/Name']}'

2. URI to restore the first item found in the previous HTTP request:

_api/web/RecycleBin('@{first(outputs('Send_an_HTTP_request_to_SharePoint')?['body']['value'])['Id']}')/Restore

[jjcook]

Hi there, 

Thank you so much for your help. I really appreciate it. 

Unfortunately I haven't managed to make it work, could you kindly let me know what I am doing wrong. I have attached my workflow below. Apologies, I am very new to this!

Thanks again. 

[Expiscornovus · Accepted solution]

Hi @jjcook,

You are missing the Headers in both HTTP request actions.

Please add the nometadata Headers to the Headers field of the first action. (Switch to text mode with the T button on the right side to be able to copy past the below).

{
  "Accept": "application/json;odata=nometadata",
  "Content-Type": "application/json;odata=nometadata"
}

And I used the verbose Headers in the Headers field of the second HTTP request (which restores the item)

{
  "Accept": "application/json;odata=verbose",
  "Content-Type": "application/json;odata=verbose"
}

[jjcook]

Thanks so much for your help!

[jjcook]

Hi there! Thanks again for your help above, it has been such a great help to me. During testing, I have found that the flows run successfully if I delete an item from the list, however if someone else deletes an item from the list the flow doesn't work. 
I cannot see why this is the case, do you have any ideas as to why this would be happening?
Any help greatly appreciated. 

Thank you, 

Jess

[jjcook]

Hey there! Is there any chance you would be able to help me with the reply I sent below? 

'Hi there! Thanks again for your help above, it has been such a great help to me. During testing, I have found that the flows run successfully if I delete an item from the list, however if someone else deletes an item from the list the flow doesn't work. 
I cannot see why this is the case, do you have any ideas as to why this would be happening?
Any help greatly appreciated. '

Would really appreciate help on this. Thank you in advance!

Jess

[Expiscornovus]

Hi @jjcook,

Is the account used in the connection of the SharePoint action site collection admin of the site?