I have a SharePoint list (Intake Directory) with the following fields connected to my PowerApp:
Department (drop down - datacardvalue19)
Executive Sponsor (text)
Project Sponsor (drop down)
I want the user to select a value from the Department drop down and have the corresponding Executive Sponsor value auto-fill and the Project Sponsor drop down values to only show those project sponsors associated to the Executive Sponsor that was selected.
I'm running into an issue getting the Project Sponsor field to filter the way I need it. I've tried this but it's not working:
Filter(Choices([@'Intake Directory'].Project Sponsor); Value in Filter([@'Intake Directory'],DataCardValue19.Selected.Value))
@Chris Webb I'm not sure what you mean by "there is no relationship to filter off". I have this working on another PowerApp where when a user makes a selection in a drop-down field, two other text fields auto-fill based on what is displayed in a single SharePoint list.
Here is an example of what my list looks like for the current app:
|Department||Executive Sponsor||Project Sponsor|
|HR||John Smith||Jane Doe|
Chris St. John
On my app if a user selects ITS as the department, then the Executive Sponsor should auto-fill to Tom and the Project Sponsor drop-down should only show Michelle & Chris.