Unanswered

Deleting a record from two related sharepoint lists

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Suppose I have Sharepoint List A and Sharepoint List B.

Sharepoint List A (main list)

Name	ID	Profession	Age	Gender
John Doe	1	Engineer	36	Male

Sharepoint List B

ID	Company	Company ID
1	ABC industries	123

The ID column in Sharepoint List A is the built in ID column of Sharepoint and I'm using that ID as reference in my Sharepoint List B.

Now my question is, let's say I delete the record in Sharepoint List B, how do I make it so that the related record in Sharepoint List A would be deleted as well?

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

WarrenBelz 156,576 Most Valuable Professional on at

Like
a
(4)

Report
Copy link

Link copied!
Hi @Anonymous ,

I am assuming the field in List B is not called ID (you already have one of those built-in), so I will use the name IDRef (change to yours). You also did provide the code you are using to delete the record in List B, however it would look something like this if you were deleting the one in List B from a gallery

UpdateContext({varRefID: ThisItem.IDRef}); Remove(ListB,ThisItem); RemoveIf( ListA, ID = varRefID )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
WarrenBelz 156,576 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps