Having issues with filtering column in PowerApp with dropdown

[MicroMarc365]

Hi, 

I'm working with a drop down field in PowerApp that is pulling data from a SharePoint list.  In the drop down field, I would like certain names to populate.  For example, I've created a mockup SharePoint list

Name (Single Text)	Email (single text)	Department (Drop-down)
John Smith	JohnSmith@smith.com	HR
Jane Smith	JaneSmith@smith.com	Accounting
Ben Smith	BenSmith@smith.com	NA
Tina Smith	TinaSimth@smith.com	Accounting
Aaron Smith	AaronSmith@smith.com	HR

In the name drop down field in PowerApp, I would like it to populate only the names that are assigned to the HR and Accounting Department.  So, all the names besides Ben Smith should show up in the drop down. 

Would really appreciate the help.  Thanks! 

[v-qiaqi-msft · Accepted solution]

Hi @MicroMarc365，

Set the Items property of the dropdown as below:

Filter(list, Department.Value="HR" ||Department.Value="Accounting").Name

[MicroMarc365]

It worked!!! I removed the ".Name" at the end and it worked! 

Next question, how do I make sort it by ascending now?