I have a SQL DB with 2 Tables: Students and Subjects
Im using @RezaDorrani Grid video as my guide.
I want the dropdown control to get it's items from the Subjects table but display the current value of the Subjects field from the Students table.
I cant seem to get the DefaultSelectedValues property to accept ThisItem.Subjects. It gives me this error: "Expected Table Value"
I get the same error even if I manually specify an Items value set.
I've searched MANY posts but there doesnt seem to be much out there about Modern Controls using anything other than SharePoint lists as the source.