I'm asking for help from the community since I'm still a newbie.
I have 2 tables Courses and Students. They are related by the n:n relationship. Inside each form in the apps there is a subgrid that displays a list of students who are attending a course or a list of courses that a student is taking.
Task
I want information to be automatically recorded in certain columns on the number of courses that the student bought (so that in a separate Profit field I can simply add the price of each) and the number of students (in order to simply multiply the price of the course by the number of entries in a similar field)
Problem
I absolutely don’t understand how to pull data from the subgrid or how to access it at all. That is, conditionally, 4 students are enrolled in a separate course, how can I automatically get this count?
It is desirable that the solution to the problem be through Flow Automate.
I think it’s possible through JS libraries and somehow linking a subgrid and a column, but I don’t know at all about the libraries that are already built into Dynamics 365