Answered

Trigger Delete SharePoint Item action from child list upon changes on parent list

(0) Share

Report

Posted on by rameshmukka

1,115

I have a parent list and child list, items in child list are subset of parent list. The ID column from parent list is being used as a reference for child list. I would like to delete child list item when the referenced parent list item's status changed to "Closed". The flow that I have currently is deleting all the records from the child list. How my Delete action should look like if I have to delete only single item from child list.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

v-alzhan-msft on at

Like (0)

Report

Hi @RameshMukka ,

Could you please share a screenshot of the configuration of your flow?

You need to check for the items in the child list, and only delete the item which's special column are same with id of the special item in the parent list.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
rameshmukka 1,115 on at

Like (0)

Report

@v-alzhan-msft I have exactly tried your way, but it is deleting all my list items in child list. It should delete only one item though. In summary this is how my 2 lists are

Primary List got ID, other columns
Secondary List got ID, other columns and ReferenceID. ReferenceID is to understand which item from primary list is being referred to here. Every item in child list is referencing to parent list using this ID.

Now what I want is - If ( PrimaryListItem.Status = Closed) then Delete Secondary list item where SecondaryListItem.ReferenceID = PrimaryListItem.ID. Here is my current flow.

When compared with your flow, I just added another condition somehow the condition fails and flow doesnt reach delete action.

Was this reply helpful? Yes No
rameshmukka 1,115 on at

Like (0)

Report

@v-alzhan-msft When I try to debug, in below way I found the condition should be matched. Dont understand why its failing

Was this reply helpful? Yes No
Verified answer

rameshmukka 1,115 on at

Like (0)

Report

Ok the problem was ReferenceID column I was using in child list was of type string. I have changed it to number and it started working.

Was this reply helpful? Yes No