Hello,
We are using a few Choice columns, and in one of the combo boxes, we want to exclude 2 options
Problem 1
The filter itself works, but it then throws this "Table doesn't contain any column of Text type error"
If I embrace the code with [ ] to make it a table, it then breaks my patch, which is the usual
Problem 2
specific_combobox.Selected.Value
The type of this argument 'abcd_specificchoices does not match the expected type 'OptionSetValue (Specific). Found type 'Table'
I can't find an answer to that, and if I leave the code as it is in Problem 1, I worry that it will affect the performance of the app (it doesn't so far)
I wonder if this is because the combo box is inside a component?
Any help would be appreciated, thank you
Problem 1
//Items in 'Specific Needs' combo box - gives the 'Table doesn't contain any column of Text type'
Filter(
Choices('Specific Needs'),
Value <> 'Specific Needs'.'Special Care Needed' && Value <> 'Specific Needs'.'Other (Alternatives)'
)
Problem 2
//Items in 'Specific Needs' combo box as a table with [ ] - it fixes Problem 1, it creates new problem
[Filter(
Choices('Specific Needs'),
Value <> 'Specific Needs'.'Special Care Needed' && Value <> 'Specific Needs'.'Other (Alternatives)'
)]
New problem created
//Patch to dataverse my choice column is broken as it is now reading a table rather than a set choice, and it needs a set choice
'Specific Needs Choices': dvc_SpecificNeeds_cmb.Selected.Value,
I also tried it with the below and the same error occurs
Filter(
Choices('Case Recordeds'.'Specific Needs Choices'),
Text(Value) <> "Special Care Needed" &&
Text(Value) <> "Other (Alternatives)")
