delegation support for gallery filter coming from seach box and 3 dropdowns

[AmitLoh-Powerap]

https://powerapps.microsoft.com/en-us/tutorials/delegation-overview/

Some notable items missing from the above list:

• If
• +, -, *, /, Mod
• Concatenate (including &)
• ExactIn
• String manipulation functions: Lower, Upper, Left, Mid, Len, ...
• Signals: Location, Acceleration, Compass, ...
• Volatiles: Now, Today, Rand, ...
• Context variables and collections

Now I have a gallery with cdm table containing 100k records and I have multiple filters-

search, country dropdown and product dropdown. How we achieve gallery filter without loosing 500 items scrolling effect. If i use if condition gallery only brings 500 and scroll stops bringing 500+ items.

[AmitLoh-Powerap]

gallery on right and I have search on top and then country and product filters, if in filters kills 500+ in gallery items scrolling