Answered

Delete all Dataverse data related to a specific match in a lookup table

(1) Share

Report

Posted on by JN-19081230-0

In my canvas app, I have three tables. For simplicity call them actor (Primary text column:ActorName) , movieactor (Primary column: ID) , and movie (Primary text column; MovieName). I have a table showing info about the movie, and the actors having played in them.
I have a delete button, so the user can delete the movie they no longer are interested in. So far so good (

Remove(Movie, tbl_Movie.Selected))

, the problem starts when I first want to delete all related rows in the movieactor table that contains this movie. How can this be achieved by Power Apps formula?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

anandm08 1,936 Super User 2024 Season 2 on at

Like (1)

Report
hi @Jan_Henrik ,
To achieve this in PowerApps, you'll need to delete the related rows in the movieactor table before deleting the selected movie from the movie table. You can use the ForAll function along with the Remove function to iterate through the related rows in the movieactor table and delete them. Here's how you can do it:

// Step 1: Identify related rows in the movieactor table ClearCollect( relatedMovieActors, Filter(movieactor, MovieID = tbl_Movie.Selected.ID) ); // Step 2: Delete related rows from the movieactor table ForAll( relatedMovieActors, Remove(movieactor, ThisRecord) ); // Step 3: Delete the selected movie from the movie table Remove(movie, tbl_Movie.Selected);

Was this reply helpful? Yes No
JN-19081230-0 49 on at

Like (0)

Report

Thank you very much, this fixed my problem😀

Was this reply helpful? Yes No