**Deleted most of this post because it's an embarrassing TMI situation!**
Coming back to Power Apps after a break I think I forgot everything I learned :-( Please be patient...
I am using a SharePoint List as my data source . My Dropdown Control selects a choice from ColumnA and stores their name in ColumnB. If there is already an entry by someone else in that row in ColumnB, that name should show automatically in the dropdown, and the control show as disabled so that the user cannot change the selection.
I cannot get this to work. My dropdown is disabled when the column is not empty, but does not show the entry that is in there.
Default: varR1Chosen
DisplayMode: varRound1Mode
OnChange: Set(varR1Chosen, dd_R1.Selected.Value)
The varR1Chosen and varRound1Mode variables are set when the user selects their own name in another dropdown.
OnChange:
Set(varR1Chosen, LookUp(colNames, Title = dd_UserName.Selected.Value, Round1));
Set(varRound1Mode, If(!IsBlank(varR1Chosen), DisplayMode.Disabled, DisplayMode.Edit))
The collection colNames is created on start from the data source in SharePoint.
What am I doing wrong?