So..I know this must be something simple, but I can't figure it out. I want to set the default selected value on an edit form for an employee.
Dropdown items come from a SQL Azure table (dbo.Units which has 2 fields UnitID & UnitName).
Dropdown.Items = '[dbo].[Units]'
Dropdown.default - LookUp('[dbo].[Units]',UnitID=ThisItem.UnitID,UnitName)
Why doesn't this select the right unit name? It always returns the first unit in the table.
Thanks. That still doesn't select the correct value:
I've tried putting this on the default for the datacard and the dropdown control itself. Neither work.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand