Delte an Item from a SUb list when its deleted in master list

(0) Share

Report

Posted on by mmbr1606

14,605 Super User 2025 Season 2

Hey everybody,

I show u my screenshot to give u a n overview of another flow i built. I have a masterlist and 3 sublists. I have a column i sharpoint where i store the information which sublist the item is for. So when i create a new item in the masterlist and set one of the 3 sub lists in the SiteCollection column, the same item will be created/modified in list a or b or c. Therefor i use the Switch function.

I pass the Identifyer of the masteritem to the subitem (so i can check if the same item is already in one of the sublists and i can make sure the right item will be updated when necessary).

I need exact the same thing but the difference is, i want to delete the item in one of the 3 sublists when i delete it in the masterlist.

I can not use the Swtich function like i did in the one of the screenshot because the "when an item is deleted" trigger does not offer me the column "Sitecollection" in the dynamic content.

Can somebody help me recreate what i did when adding/modifying the item?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Unknown geen idee 1,757 on at

Like (0)

Report
Dear M,

To me it sounds like you just need to do the following:
Get the ID of the item you have deleted from the Master list (assuming this is the data element which will also identify the item in any of the sublists).
Pull the data of the sublist, likely you will use a 'List rows in table' or 'Get items' depending on how your sublists are organized.
Filter the output of step 2 with a 'Filter Array' using the ID (of the deleted Master list item). If there is a match, delete the item from the sublist.
Do step 3 for all the sublists.
Hope the above helps,
Happy flowing,
Koen

PS. For other users, please indicate as solution if this is the case.

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report

I
Here is what i tried, but the flow fails with the error:
The execution of template action 'Switch' failed: The result of the evaluation of 'scope' action expression '@items('Apply_to_each')?['SiteCollection/Value']' is not valid. It is of type 'Null' but is expected to be a value of type 'String, Integer'.

Is it possible that i dont get that item which is deleted when i use the Get Items of the masterlist because its already gone?

Was this reply helpful? Yes No
Verified answer

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report

I found a way to do it, comparing the name of the two items (they are uniqe)

Was this reply helpful? Yes No