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!
I think the issue is related to the usage of FirstN/LastN, it returns the table with different metadata. I'd check the output first and compare. Maybe you can use a dot after FirstN(), LastN() function to use the output of a function? You can try.
Let me know how it goes.
Best regards,
Artur Stepniak
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
16
Share
Report
All responses (
Answers (
