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
Super User
Super User

@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
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (2,600)