I would normally set a dropdowns (drpdown1) item property in List1 to a secondary datasource (Ex. List2) and then select the field (description) I want to use for the choices in the dropdown. To set addional form fields based on a choice I would use the following formula in the default property of the form field: drpdown1.Selected.PartNumber. This works great, but I need to add a blank default value for drpdown1 so i used the following formula in the items property
Ungroup(
Table(
{Options: Table({Description: Blank()})},
{Options: List2.Description}
),
"Options"
)
When I use the above formula it obviously breaks the connection to the other fields using drpdown1.Selected.PartNumber for instance.
I've tried replacing drpdown1 with Options instead and that doesn't work either. I don't know what to use in the additional fields now to grab the lookup values in the default property. Any ideas on how to overcome?
My main issue is getting those fields to show blank, If I don't the dropdown field uses the first choice in the list and fills the other fields accordingly, which confuses users when they open a record from a list view that clearly shows other values in those columns.
