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.
Continue your learning in our online communities.
Next Wednesday, September 18th at 8am PDT
Features releasing from October 2019 through March 2020
Coming to a city near you
Fill out a quick form to claim your user group badge now!
Connect, share, and learn with your peers year-round
Register by September 5 to save $200