I have a combobox that has options from this Items Property formula:
Sort(
Filter (
'AAD Users',
'Microsoft Entra Identity Account Enabled' = 'Microsoft Entra Identity Account Enabled (AAD Users)'.Yes && 'Microsoft Entra Identity id' <> GUID("4378jb64-2097-4771-2569-53f8976d27c23") && Not(
StartsWith(
'Display Name',
"svc"
)
)
&& Not(
StartsWith(
'Display Name',
"SNY"
)
)
&& Not(
StartsWith(
'Display Name',
"Azure"
)
)
),
'Display Name',
SortOrder.Ascending
)
However, I am in need to have a value of Unassigned if none of the options are selected (field is left blank) or be able to add "Unassigned" as an option.

Report
All responses (
Answers (