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.
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications