Unanswered

Combobox Not displaying some of the records in the list

(0) Share

Report

Posted on by CU24102319-0

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:

Using Apps Using Formulas

All responses (2)

Answers (0)

WarrenBelz 143,487 on at

Like (0)

Report

Combobox Not displaying some of the records in the list

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 Buy me a coffee
WarrenBelz 143,487 on at

Like (1)

Report
Combobox Not displaying some of the records in the list

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