Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Delete SharePoint List item NOT by List ID

(0) ShareShare
ReportReport
Posted on by

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,

 

  • Re: Delete SharePoint List item NOT by List ID

    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

  • Daniel_Reuter Profile Picture
    Daniel_Reuter 3 on at
    Re: Delete SharePoint List item NOT by List ID

    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.

  • Verified answer
    v-yuazh-msft Profile Picture
    v-yuazh-msft on at
    Re: Delete SharePoint List item NOT by List ID

    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:

    Capture.PNG

     

    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

     

     

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard

Featured topics