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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,968 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Gauzdx 15 on at

Like
a
(1)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,968 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No