I have a SharePoint list with called Service Areas and Directors with 2 Columns: DirectorList & Team
The DirectorList column specifies the category which each Team sits within. I am trying to create a PowerApps customization for the New and Edit forms to allow me to select the Director and in my first drop-down list and then select Team from a filtered list of those reporting to that Director from the second.
To this end I have created 2 Text Columns called ServiceDirector and ServiceAreaTeam. These are in a list view and the list form has been customized with PowerApps.
The ServiceDirector datacard has had the text control replaced with a dropdown list called ServiceDropdown3. The 'Update' field contains the following: ServiceDropdown3.Selected.Result
The Items field of ServiceDropdown3 contains the following: Sort(Distinct('Service Area and Directors'.DirectorList, DirectorList), Result, Ascending)
The ServiceAreaTeam datacard has had the text control replaced with a dropdown list called ServiceDropdown4. The 'Update' field contains the following: ServiceDropdown4.Selected.Team
The Items field of ServiceDropdown4 contains the following: Filter('Service Area and Directors',Team=ServiceDropdown3.Selected.Result)
When published the App produces no errors and the first drop down functions as expected, producing a selectable list of Directors with no duplications. The second dropdown remains blank.
Why does the second list not produce a filtered list of teams reporting to that director, as expected?