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.
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Fill out a quick form to claim your user group badge now!
Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities
Features releasing from October 2019 through March 2020
Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications