If you have found yourself working w/ some larger Collections, Excel Tables, or other data sources, you'll find some limits that you start to hit. For importing data into a static Collection during design-time, that limit is 15,000 rows. Now you can of course chop up your list into multiple lists to get past this, but that can get frustrating if you're doing this lots and lots of times.
As well, some of the default methods that might "work fine" for smaller lists, appear to blow up w/ large datasets. However, w/ a little bad programming, you can get around this. Read on.
Note: Microsoft made a recent (November 2023) change that limited input lengths on Text input fields.
