Hope anyone can help. Setup a loop using the timer (which would change a forms details and update the form on each timer pass), for example now I can add and an entry into an entity eg teacher and then specify that teacher has X number of male students and X number of female Students .
This would then automatically add (X+X) records in the student entity and assign gender accordingly .
At first I created a one to many relationship in Power BI but this had limitations/issues around summing up lookup values (also used).
I then looked at creating a one to many relationship between my entities (within the entities themselves) but when I tried to add this relationship to a form that I could update with my loop in the same way, I cant figure how to add/update the relationship field automatically. If I add a field from the relationship to a form it becomes a drop-down and I cant default or change it unless manually selecting.
Any help would be appreciated
Solved! Go to Solution.
Thanks for your follow up on the solution to your issue here. It can be very helpful to other communities members so I do appreciate it. Here is a little more information if you would like to learn more, feel free to take a look.
Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check it out!
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021