cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
NickMorrell
Level: Power Up

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

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)

20190211datasource.png

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

20190211apptest.png

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):

20190211clearcascadingdropdown.gif

 

Hope this can be helpful.

Best Regards.

Yumia

 

 

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

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

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)

20190211datasource.png

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

20190211apptest.png

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):

20190211clearcascadingdropdown.gif

 

Hope this can be helpful.

Best Regards.

Yumia

 

 

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,932)