Answered

Delete SharePoint List item NOT by List ID

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

The goal: create a flow when deleting a sub-list item, the aggregate main list will also remove the same item

Situation: I have multiple lists feeding into the main list through flow (trigger: create item -> action: create item). I tried to do the same with deletion, and I am limited to the "delete item" action which only asks for list ID.

Complication: the list ID of a new item in the sub-list is different from the ID of the new item in the master-list. I end up deleting the wrong item.

Hypothesis:

- is there a way to ask the delete action to use a different ID value?

Thank you,

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-yuazh-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous,

If you want to delete the item in the list2 (look up list) when an item is deleted in the list1 (In use list),please refer to screenshot below to create the flow:

The item in the look up list would be deleted when an item is deleted in the In use list.

Note:

Please make sure the Title of the item In use list would have the same Title in the look up list.

Best regards,

Alice

Was this reply helpful? Yes No
Daniel_Reuter 3 on at

Like (0)

Report
Copy link

Link copied!

After some small adjustments, the above solution worked as a charm. Had a really hard time finding a solution to this problem. Odd that the method of deleting items from list B when deleted in list A is different from the method of creating or updating items from one list to another.
One would argue that it would be beneficial to include the "delete" functionality in the "create/update item" functionality.

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

Like (0)

Report
Copy link

Link copied!

May I know if there is a way to delete items other than using ID or Title? As ID on both lists are different and Title is not a required column in my case. It would be best if I do not have to change the structure of my existing sharepoint lists as well.
Thank you

Was this reply helpful? Yes No