Power Platform Community Forum Thread Details

Good Day,

I've been searching these forums for a couple of days now and unfortunately I'm not finding a solution. I'm sure it's something easy I'm missing-so I apologize in advance if this topic has been answered in a previous post

Essentially I have a combo box that is going out to another SharePoint list-the box works as expected until I save/submit the form at which point it clears and doesn't save the value that was selected.

The combo box looks at another field (business unit) and filters down the collection based on the business unit) However, as I said, the selected value clears when I hit save and doesn't show that any selection was made in the version history.
I've commented out various solutions I've tried or couldn't get the formula to take correctly as shown in the screenshots provided.

Thank you kindly for your assistance!

OnStart:

ClearCollect(
col_LocationsNC,
'Who Does What by Location'
);

Items: RenameColumns(
ShowColumns(
Switch(
dpdBusinessUnit.Selected.Value,
"CFN US",
Filter(
col_LocationsNC,
ThisRecord.'Business Unit'.Value = dpdBusinessUnit.Selected.Value
),
"REG",
Filter(
col_LocationsNC,
ThisRecord.'Business Unit'.Value = dpdBusinessUnit.Selected.Value)),
"ID",
"LocationNameandCode"
),
"ID",
"Id",
"LocationNameandCode",
"Value"
)