I am attempting to create an autocomplete on a text input box on a form. As such, I have replaced the text box with a combobox. I have set the items property of the combobox to:
[@Projects].'Customer'
and the update property of the datacard to:
If(IsBlank(DataCardValue36.Selected.'Customer'),DataCardValue36.SearchText,DataCardValue36.Selected.'Customer')
This all seems to work.
However, I would also like to limit the display to Distinct values in the combobox. But when I change the items property to:
Distinct([@Projects].'Customer',Customer)
Then the update property fails with "the function if has some invalid arguments."
Can anyone guide me how to fix the code in the update property of the datacard?
