Clear blanks in a dropdown list, and auto-populate other fields

[NickMorrell]

Hey everyone,
Very new to PowerApps. I have a dropdown list, and it shows values from a column that also contains some blank cells. How do I configure the list to only show the non-blank cells? And, how can I make it show a blank as the default selection rather than the first value in the column?

Next, I want the selection from the list to auto-populate some other text fields on the page. How can I make the fields fill with values corresponding to what is picked in the dropdown?

These fields I want filled come from a different table. The dropdown is the column "PYEmployeeCode" from the table RMEmployee; I need to autofill two fields with the corresponding values from the "Surname" and "Firstname" columns in the PYEmployee table. So, how can I make the connection between RMEmployee's "PYEmployeeCode" column and PYEmployee's "EmployeeCode" column? 

The attached image is a rough representation of the two tables. They're actually different Sheets in the same Excel workbook.

Thanks so much for your help.

[v-yuxima-msft · Accepted solution]

Hi @NickMorrell,

For your first question

Do you want to the dropdown’s first item blank and other items not blank from table’s value?

For your second question:

Do you want the field of Firstname and Surname are auto filled by the employeecode to be selected?

I think you can try following workaround.

I test as next:

DataSource(as screenshots show next)

App Test :

For your first question:

Add one Button and rename Button_Collect,Button_Collect.OnSelect: ClearCollect(dropdownwithblank,{Name: Blank()});Collect(dropdownwithblank,Filter(Table3, !IsBlank(Name)).Name)

Dropdown_blankdropdown.Items: dropdownwithblank.Name

For your second question?

Dropdown_Code.Items: RMEmployee.PYEmployeeCode

Label_Firstname.Text: LookUp(PYEmployee, EmployeeCode=Dropdown_Code.Selected.Value).Firstname

Label_Surname.Text.Text: LookUp(PYEmployee, EmployeeCode=Dropdown_Code.Selected.Value).Surname

Result Test(both question 1 and question2):

Hope this can be helpful.

Best Regards.

Yumia

[kmw1130]

How can I do this with a Distinct?  This is my formula, but my dropdown is not showing anything.  Instead of a blank, I want it to say All as the default.

ClearCollect(collectAgency, {Result: "All"});
Collect(collectAgency, Filter(PIT, !IsBlank(CustomerAgency)).CustomerAgency);