Power Platform Community Forum Thread Details

Hey! I have a Sharepoint Form that some Fields are set to be options based on an Excel table. For one column it's working perfect, and even if I insert a new ComboBox and use the default options, everything fine (By fine I mean it allows me to search and it even allows me to search for words other than the initial one. Example, full data is "Not referenced", i can search just "referenced" and it shows).

The problem is the other column, it's called "Número Producto". I thought the error was because of the 500 limit, because the dropdown does show only up to the 500th item. But even if I try searching for the 1st item in the Excel, it shows this error

Error trying to recover data from the network: !sAj1K!' and or expected at position 16 in 'contains(Número Producto)'. Ploc ! inner exception: !sAj1Kry or expected at position 16 in 'contains(Número Producto:r)'. Ploc ! clientRequestld: 030f8e13-f2d4-40c0-b80d-c9c3fcea0973

Furthermore, I have to set this so these two dropdowns are codependent on each other (I managed to do this following this: Solved: Re: Sharepoint form: codependent comboboxes? - Power Platform Community (microsoft.com))

On these two dropdowns I have the following setttings:

in OnChange: UpdateContext({locSelectedAccount: Self.Selected})

In DefaultSelectedItems: Coalesce(locSelectedAccount)

I of course have been trying without this variable, so that is not the reason of the error. Even weirder, if i set the non-error Dropdown to the 30000th item in the Excel, it will change to the correspondent item in the error-dropdown. So, PowerApps IS recognising that column, but for some reason I just can't search it.

Edit: I think that on one hand, part of the issue is that the Excel column name has a special character "nÚmero". Also, all values in that Número column start with number, if the column name does not have special characters I do not get that error, but it does not search for the numbers.

Categories:

Building Power Apps