Hello PowerAppers,
I am facing an issue and hope you might have some ideas on how to tackle it. I have already looked through related topics and answers, and I have enabled the 'Record scope for many-to-many relationship' in the experimental features of the settings section of the app.
I have two tables: Team and Accelerators, with a 'many-to-many relationship' between them. I have added a subgrid in the Accelerators form to enable adding Teams.
In my Canvas App, I have two dropdown controls for Team and Accelerators. The Team dropdown's Items property is set to a global variable that displays only the Teams the current user is assigned to.
What I am looking to do is to display in my Accelerator dropdown only those Accelerators which are related to the current Team chosen by a user in the Team dropdown control in the Canvas App.
Typically, the formula would look something like this:
Filter(Teams, Team.Name = DropDown.Selected.Name)
but it is not applicable in my scenario. Any ideas on how to approach this issue?
Many thanks,
Anna
