Delete Item in a SharePoint List when Deleted in another SharePoint List

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I have two almost identical SharePoint Lists. One List is used by my users at Power Apps. The other List is a backup.

So, when my users delete an Item, it should be deleted in the backup list too.

But, when i tried to create a flow to delete an item when it is deleted in the List users work, there is only the option to delete through the ID of the item, but my lists does not share the same ID.

There are some other way to run it?

Best regards,

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (2)

Verified answer

mcin9781 on at

Like (1)

Report

Hey Rodrigo,

You could have a custom ID field on the backup list that identifies with the original list to select the file to delete. Let me know if this help.

Was this reply helpful? Yes No
Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (1)

Report
Hello @Anonymous ,
if the items have unique 'Title', you could add 'Get items' action to the backup list, use filter to get only items with the same title as the deleted item, and then delete it using the returned item ID.
Title eq '@{triggerOutputs()?['body/Name']}'

If the item 'Title' is not unique (you've got multiple items with the same title), then I think you'll have to store the ID of the original item in the backup list and use the same logic, just based on the ID instead of Title.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello @tom_riha ,

This solution was the first thing i thought. But the "Title" field to choose that is the one unique at my lists does not appers at the dynamic content.

Look what i did. When an item is deleted, get items. In the filter Query, the field Title is not appearing..

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @mcin9781 ,

I have a custom ID, but in the collumn Title. That is the option that does not appears at the filter query.

Best regards,

Was this reply helpful? Yes No
tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

For the trigger 'When an item is deleted' the item title is the 'Name' dynamic content, the filter query should be exactly as on the screenshot I posted.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks @tom_riha !

It worked!

Best regards,

Was this reply helpful? Yes No
Neha12 31 on at

Like (0)

Report

Hi @tom_riha

I used the same flow
I used both the id column in filter query
But the flow is deleting in row order sequence not mapping with ids, it doesn't delete the same ID from source to destination, instead it deletes the ID with same row number that was deleted in source

Please help

Was this reply helpful? Yes No