Power Platform Community Forum Thread Details

Dear all ,

I would like to get more detailed information including all columns‘ value ，created date of a deleted SharePoint list item.

I use the “When an item is deleted ” trigger and “get item ” as the subsequent action.

But，the “get item” action cannot find the item that has been deleted.

How can I get me what I want? Thanks

Categories:

Building flows

Hi,

by delete trigger in power automate, we can't actually get all the fields values from list item.

So as a workaround- what we have to do is

1. Get the deleted item details from recycle bin

2. restore the list item

3. get the required values from that list item

4. delete that list item

so the flow designed for this is like below

1. use trigger when item is deleted

2. use send http request to sharepoint to get details of the deleted list item present in recycle bin by using below HTTP get request

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

3. Now using the above output from http request- use parse json action to parse the json string

4. use send http request to sharepoint action to restore the list item

HTTP URI- _api/web/RecycleBin('@{first(body('Parse_JSON')?['value'])?['Id']}')/Restore

5. Since List Item has been restored, now use get item to get the list item details

6. Now we need to use update item to update Title property of List item by appending_Deleted string to title value, so that flow could understand that list item was already deleted so that trigger won't run again as at last of this flow- item will be deleted.