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.