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.
Featuring samples like Return to the Workplace and Emergency Response Applications
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
We are excited for the next Super User season.
Features releasing from October 2020 through March 2021