Combobox Search Unexpected Characters. The formula contains 'ParenClose' where 'eof' is expected.

(0) Share

Report

Posted on by HeihoSilver

Hi,

I put the Combobox in a form. The data source is Sharepoint and the column has "Single line of text" data type.

Here is my code on the combobox Items:

Sort(Filter(Table1, Type1 = Dropdown6.Selected.Value).Name1, Name1)

I used Sort and Filter function, where the filter is referring to dropdown 6.

My "DefaultSelectedItems" is

{Name1: Parent.Default}

The Datacard Update is

ComboBox6.Selected.Name1

The error/issue occurs when I switch the toggle "Allow searching" or "IsSearchable" to "True". There is no issue when I switch to False.
When it's error and I click on "Edit in the formula bar" it always pointed to "DisplayFields" which I think there is no issue.

When pointing to "get help for this error", it says Unexpected characters....

So I'm not sure what is the issue here. Error Unexpected Characters.JPG

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
Can you please try adding below formula in "DefaultSelectedItems" of ComboBox:
{Value: Parent.Default}

Was this reply helpful? Yes No
HeihoSilver 87 on at

Like
a
(0)

Report
Copy link

Link copied!

@NandiniBhagya20
Thanks for the suggestion with {Value: Parent.Default}, but the issue remain the same.
Changing this also make the combobox became blank when editing the form.

Was this reply helpful? Yes No
HeihoSilver 87 on at

Like
a
(0)

Report
Copy link

Link copied!

Sometimes when I clicked in the "Edit the formula bar", it is either go to "DisplayFields" or "AccessibleLabel". Have no idea with this behavior and how to solve it.

Was this reply helpful? Yes No
Verified answer

HeihoSilver 87 on at

Like
a
(0)

Report
Copy link

Link copied!
After trial and error I just found the solution.

I clear up the code in the Items, and use the "Depends on" functionality in the Properties and set the required dependencies accordingly.

The code in the Combobox Items became like this, which is ok, but not sorted alphabetically.
Filter(Table1, Type1 = Dropdown6.Selected.Value)
After that I changed the code manually to my original code which is
Sort(Filter(Table1, Type1 = Dropdown6.Selected.Value).Name1, Name1)
And it works, no issue or error found!

Maybe it got something to do with the apps reference which may haven't been looked for. Maybe by using "Depends on" functionality at first may helps the apps to create reference for searching items.

Was this reply helpful? Yes No