Unanswered

500 items limit on listbox items with cdm entity

(0) Share

Report

Posted on by AmitLoh-Powerap

608

how to fix 500 items limit on listbox items with cdm entity. I have CDM products entity with 800 items and I want to use multiselect filter to filter products. This is a requirement. I can not use gallery as I need multi select filter.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

AmitLoh-Powerap 608 on at

Like
a
(0)

Report
Copy link

Link copied!

even if I put comma seperated items it gives bellow.

Was this reply helpful? Yes No
Brian Dang 3,976 on at

Like
a
(1)

Report
Copy link

Link copied!
I recommend using a combinatin of Gallery and a Collection to simulate the multiselection capability of a ListBox.

Add Gallery1.
Add Button1 into Gallery1 to show your items.
Set Button1.OnSelect to collect that item into Collection1:
If(ThisItem in Collection1, Remove(Collection1,ThisItem), Collect(Collection1,ThisItem) )
This means, "If the item you select is already in Collection1, remove it, otherwise, add it to the collection." It is pretty much multi-select.
Set Button1.Fill or Gallery1.TemplateFill to show that an item is in Collection1 (show that it is multi-selected):
If(ThisItem in Collection1, RGBA(color you want to use for showing selection), RGBA(0,0,0,0) )
I recommend setting either a button, the OnVisible, or OnHidden properties of the screen to clear the "multiselection."
Clear(Collection1)
To reference the multiselection to filter another gallery, use in or exactin:
Filter(Gallery2, field exactin Collection1.field )
ListBoxes are convenient, but I find Galleries much more flexible.

Was this reply helpful? Yes No
AmitLoh-Powerap 608 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks. How do I unselect. I do not want to overcomplicate my scripts. I need listbox behavior using listboxes. I am now trying to find a workaround on how to get around 500 items limit in listboxes...

Was this reply helpful? Yes No