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