Forum Discussion
Filter drop down B by drop down A
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 ...
ChrisWebbTech 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 Mike Smith |
| ITS | Tom Johnson | Michelle Jones 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.
Oh, so this is a separate list from where the app stores data? I was under the impression that it was a single list with "choice" fields with those values, my bad :P.
- Something like this should work, if I understand the ask.
Department (drop down - datacardvalue19)
Items = 'Listname'.Department
Executive Sponsor (text)
Text = Lookup('Listname',Department = datacardvalue19.selected.value).Executive Sponsor (maybe a .DisplayName if this is a people column)
Project Sponsor (drop down)
Items = Filter('listname',Department = datacardvalue19.selected.value)- It seems like that should work...but it's not. I'm still getting an invalid argument type error on the Project Sponsor drop down.
- put a .ProjectSPonsor at the end, whatever the column name is.