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.
Solved! Go to 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
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
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);
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
206 | |
187 | |
82 | |
51 | |
37 |
User | Count |
---|---|
288 | |
244 | |
121 | |
76 | |
55 |