Share
Report
11
I have three Dataverse tables with a similar structure to these more simple examples. I am not using Dataverse Lookup columns because I plan on moving my data to SQL soon. Until then, I need to create what would be the powerapp equivalent of a stored procedure.
Essentially I need to be able to make a drop down where I can choose a class then display all the students whose ID matches up with the student_ID from the studentClasses table. I want to then be able to drop the student from that class by deleting that record in the studentClasses table.
Given that in SQL, I would probably use a join, I tried to use the AddColumns function, which is kind of working, but I am getting delegation warnings that say it might not work in a large dataset. This will eventually be a large data set so are there any other ways to do this? Is there some kind of Filter function that would work in this case? I am pretty new to power apps so I very much appreciate any assistance I can get with this.
All responses (
Answers (
