Answered

Combo box incomplete filtering results

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I'm trying to replace my old drop-down list by combo box because it can show more columns data. However, I noticed some unexpected behavior of my combo box but not sure the reason. Some of the filtered results can be missing from the combo box list, but it is not always happening. please see the following screenshots:

Missing results behavior(combo box list has some items missing):

Filtered results of drop-downs:

Filtered results of combo box (objectid = 1464 is gone):

Normal behavior (the drop-down list gives the same results as the combo box):

Here is my code for them:

Dropdown:

On select:

SortByColumns(Distinct(Filter('[dbo].[GENERAL_INSPECTION]',slip_id = cb_slip.Selected.slip_id),objectid),"Result",Ascending)

Combo box :

On select:

Filter(AddColumns('[dbo].[GENERAL_INSPECTION]',"objectid_t",Text(objectid),"ins_date",Text(inspection_date)),slip_id = cb_slip.Selected.slip_id)

Do you have any suggestions? Many thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Florian_Kleinz 227 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello,

The .Selected property of a combobox returns a table even is MultiSelect is false.
Therefore you need to get the first value of the combobox:
First(YourComboBox.SelectedItems).Value //.Value might differ depending on the DataSource of the ComboBox. In your case it seems to be .slip_id: First(cb_slip.SelectedItems).slip_id

Let me know if this helps.

Best regards

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous :
I guess your problem is caused by "delegation restriction".To verify my guess, could you tell me:
What is your data source?Is it SQL sever?
How many records are in this data source?
Please set the Combo box's Items proeprty to:

AddColumns( Filter( '[dbo].[GENERAL_INSPECTION]', slip_id = cb_slip.Selected.slip_id), "objectid_t", Text(objectid), "ins_date", Text(inspection_date) )

I just changed the execution order of AddColumns and Filter. If this formula can get the correct result, it can prove that my guess is correct.
Best Regards,
Bof

Was this reply helpful? Yes No