Deleting items in Sharepoint list that is is another Sharepoint list

[Anonymous]

Hello, I have list A and list B, and I want to delete items from list A that is in list B using a flow. Is this possible?

[eric-cheng]

Hi @Anonymous ,

You will need some sort of identifier or value that exists in both lists to match them up.

1. Get Items in list B

2. For each list item, Get Items in list A.   Use an ODATA filter e.g. Title eq 'Column B value'

3. Delete item

This is one way, there are probably a few other ways of achieving the same result.

-------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[Powerplatform01]

@Anonymous 

You can take help from this video

https://youtu.be/639qnKw85n8

Request you to please subscribe this video

[Anonymous]

I tried the video instructions but it either deletes my entire list or does not delete any entry.