cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NickMorrell
New Member

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
v-yuxima-msft
Community Support
Community Support

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

2 REPLIES 2
v-yuxima-msft
Community Support
Community Support

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

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

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (79,675)