Weird combobox issue in populating items

(2) Share

Report

Posted on by Gauzdx

I have a combo box that takes in a collection 'colData' as variable in the 'Items' property. This collection is clear collected by filtering a SharePoint list when a button is clicked. Below is the function of that button:

ClearCollect(colData, Filter(SharepointList, PKey = varPK));

Above function will always return 1 record from the SP list.

This button is selected automatically when user navigates to the screen using 'OnVisible' property. Fields property of the combo box are set to the fields that are in the collection 'colData'. I have inspected this collection and it is fetching the correct data I want. Weird issue I am having is that it is working for all "varPK" except for one. Combobox would populate correctly and show values as specified in field but it won't populate with item when I pass a specific "varPK" variable.

I have checked formatting of the "varPK" variable multiple times in both PowerApps environment and the datasource and it looks correct to me. If things were wrong, it shouldn't work for other variables as well..

Why is this behaving in this way?

Categories:

Using Apps Using Formulas

Connecting to Data

All responses (3)

Answers (0)

Suggested answer

Michael E. Gernaey 41,254 Super User 2025 Season 1 on at

Like (1)

Report

Weird combobox issue in populating items

Well..

If you had shown a picture I would have told you that. And since the thing is blank.. there is no company details to show/etc. again a simple picture saves me time and thats most important since im helping you for free.

it is a known issue. its that simple, its a known issue.

Let me explain

When you have search on, the Control will filter based on what you type. So many people will have lets say

A

B

C

D

E

F

in the Combobox.

They select A and go OMG the control is cleared.. No its not, its filtering (search). And for some reason, when you add stuff to a Combobox, and if you ever changed the code, and if search is on, it will act as if you typed a space.

Since none of them match a space its blank.

That's why it works.
Gauzdx 15 on at

Like (1)

Report

Weird combobox issue in populating items

@FLMike
Thanks for the reply. I wanted to attach pictures to show the variable values but I didn't want to expose company data so I tried to explain my issue through words.. I couldn't change data and show you because the issue was only due to that specific data.

Anyway, in terms of debugging, since the issue was specific to one specific data, I did check the data formatting as I wrote in my question. I compared it in the datasource, Powerapps environment to make sure it matches exactly. It just wasn't populating in the combobox while other data would perfectly fine. I even deleted that record from SP list and re-entered data manually. That too didn't resolve the issue. What resolved the issue was unchecking 'Allow searching' property of that combobox.

Now my question is, why did this resolve the issue?
Suggested answer

Michael E. Gernaey 41,254 Super User 2025 Season 1 on at

Like (2)

Report

Weird combobox issue in populating items

HI

Just as feedback when you throw stuff in like oh it works all the time, then immediately after change it its very confusing.

I just want to jump to what you said was wrong. With one value, it doesn't work. Please let's focus on that.

1. Explain and use pictures as to what you mean by it doesn't work for that 1?

Do you mean it doesn't find any of the values?

My initial guess and this happens a lot, is there is a Space at the end of the PKey that is stored or is being used to do the filter in the time it doesn't work.

Please start your asks with the issue, then go into details, (just for me) it requires a whole bunch of focus on things I don't need to focus on.

For the one, clearly there is a problem with the string you are using, or have stored, please share all of that, so we can help without having to guess.