Share
Report
16Dear,
I’m working on a form with multiple questions, including three combo box dropdowns where the Items property uses a conditional format like this:
If(
_ProjectTypePTD = "BN" || _ProjectTypePTD = "SN",
FirstN(Choices('Bow thruster execution (PTD informatie V2s)'), 3), // Display the first three options
If(
_ProjectTypePTD = "CN",
LastN(Choices('Bow thruster execution (PTD informatie V2s)'), 3) // Display the last three options
)
)
I’m working on a form with multiple questions, including three combo box dropdowns where the Items property uses a conditional format like this:
If(
_ProjectTypePTD = "BN" || _ProjectTypePTD = "SN",
FirstN(Choices('Bow thruster execution (PTD informatie V2s)'), 3), // Display the first three options
If(
_ProjectTypePTD = "CN",
LastN(Choices('Bow thruster execution (PTD informatie V2s)'), 3) // Display the last three options
)
)
This setup causes an error in the SearchFields property, which by default is set to ["Value"]. The error message indicates an issue with the table not containing a column of text type, even though the Choices('Bow thruster execution (PTD informatie V2s)') function works fine without any issues. I'm using a dataverse table as source in this case.
I’ve tried alternative methods like Filter and AddColumns, but the error persists when I manipulate the choices. My goal is to display only specific options based on the _ProjectTypePTD variable while retaining the combo box's search functionality.
Does anyone know why the SearchFields property throws this error or how I can resolve it? Any guidance would be greatly appreciated!
Thank you!
Best regards,
Luuk
Luuk
Categories:
I have the same question (0)
All responses (
Answers (
