I've been tasked with developing a proof of concept, duplicating a desktop-based "property browser" which was delivered by a contractor some years ago. With my other work being based in AGOL, initially I considered Web AppBuilder , Dashboards, and Instant Apps as the most direct development options. However, ArcGIS Web AppBuilder will retire in the fourth quarter of 2025 and Experience Builder appears to be the replacement.
The central function of our "property browser", must be a "pick list" or category selector which drives the filtering of ~354,000 parcels in a polygon feature set. This "pick list" or category selector must accommodate ~1,500 appraisal areas which are assigned to each parcel record. Our "property browser" must allow the user to select which parcels are displayed, grouped by a single appraisal area, or by multiple appraisal areas.
I got this set up quickly in AGOL Dashboards, but I can’t do it fully in Experience Builder. This limit within Experience builder can be seen in the attached image.

So what is the magic cut-off number?
I could use some help in navigating ESRI’s tech support world in order to determine:
1. Is the limitation with group filters in Experience Builder, as described above and unchangeable?
2. What are our other options, within ESRI, to have the functionality that we need in an application develop environment?