cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Users Online
Currently online: 233 members 5,447 guests
Please welcome our newest community members: