The datacard doesn't have a value property...the control does. I listed that in the first post (it's set to unit table). The dropdown is populating correctly with all units...the issue is I can't pass the UnitID from the Employee table and select the correct Unit in the Unit dropdown.
It has to be something simple that I'm missing...this is basic functionality.
This sounds strange. My inclination is to use this syntax:
However, the formula that you wrote originally, and the formula beneath should equally work:
I suggest that you add a label to the same card and set the Text property to ThisItem.UnitID. When you do that, does the UnitID return the value that you expect for the record? To help diagnose this issue, I think it would be a good step to confirm that.
Thanks, everyone. As it turns out, the UnitID value was returning blank. After some troubleshooting, it was a weird error while converting from a SQL view to a table. Nevertheless, my original syntax worked once I actually got data from the source.
Sorry for the confusion.
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