web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Delte an Item from a S...
Power Automate
Answered

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

(0) ShareShare
ReportReport
Posted on by 14,615 Super User 2026 Season 1

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?

 

2023-11-14_13h47_00.png

Categories:
I have the same question (0)
  • Unknown geen idee Profile Picture
    1,757 on at

    Dear M,

     

    To me it sounds like you just need to do the following:

    1. 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).
    2. 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.
    3. 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.
    4. 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.

  • mmbr1606 Profile Picture
    14,615 Super User 2026 Season 1 on at

    mmbr1606_0-1700059712402.png

    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?

     

  • Verified answer
    mmbr1606 Profile Picture
    14,615 Super User 2026 Season 1 on at

    mmbr1606_0-1700060647005.png

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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 308

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 226 Most Valuable Professional

Last 30 days Overall leaderboard