Unanswered

Combobox Not displaying some of the records in the list

(0) Share

Report

Posted on by Akshaykapadia

Hi all.

I have different filters to apply to the view and one of the filters is the filter by Asset. It's a combobox and linked to Assets table in the Dataverse. Currently there are around 700 records in the table.

When I review the data source, I can find the record but if I want to filter the list by that particular record and it is not showing up in the list for the combobox. For example, Western Down is an Asset record which I can locate in the dataverse and in the assets data source but when I type Western/Western Down it is not showing up in the list. Appreciate any help.

Filter(Assets, If(!IsBlank(RegionCombobox.Selected), 'Region (aemo_region_lu)' in RegionCombobox.SelectedItems, StartsWith('Asset Name', Self.SearchText))).'Asset Name'

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

WarrenBelz 153,495 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @CU24102319-0,

A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
WarrenBelz 153,495 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi CU24102319-0

Firstly, please post your code in text also - saves re-typing here. You have a Delegation warning there for several reasons - the in Filter and also the If statement inside the Filter. You did not post the DisplayFields (output) of the Region Combo Box - replace xxxx in the code below with this field name.

If( Len(RegionCombobox.Selected.xxxx) = 0, Filter( Assets, StartsWith( 'Asset Name'.Self.SearchText, 'Asset Name' ) ), ShowColumns( Ungroup( ForAll( RegionCombobox.SelectedItems As _Items, Filter( Assets, 'Region (aemo region lu)' = _Items.xxxx ) ), Value ), 'Asset Name' ) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No