cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to delete a SharePoint List item when a same item is deleted from another list?

Hi, I created two lists in SharePoint List A and List B. When I create a new item in A the same item will get created in B. Also I want that if I delete an item in A then the same item will get delete in B.

I also created a ID column in List B to store the ID of List A so that I can use that to update but that is not working for Delete.

I tried a lot of methods in Flow but it is not working.

Please help me with the above query.

 

Thanks in advance

Dipak Shaw

1 REPLY 1
annajhaveri
Community Champion
Community Champion

@Anonymous i think this would be better done using Lookup column, add lookup column in the List B and it will refer to ID column of List A and while creating lookup column there is a setting Enforce Relationship Behaviour, select cascade delete, which will delete items in List B when corresponding item is deleted from list A?

annajhaveri_0-1614090304644.png

 

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (4,469)