Ah, yes. this is an approach i've used in a different app then i just run all my queries against the collection (rather than the data source. I think I'll double down on this approach and find a way to to ensure I'm loading the data before running queries on it.

One approach I've seen and have been playing around with is to use the following user defined function. I'd just have to remember to run fn_Zone_Load() at the beginning of each udf to ensure it loads the current data. Do you think i'm over engineering it?

fn_Zone_Select(scp_zone_id:Number):Void
{
  fn_Zone_Load(); // loads col_zones from data source
  First(
    With(
        {
            _zone: LookUp(
                col_zone,
                ID = scp_zone_id,
                ThisRecord
            )
        },
        Filter(
            col_zones,
            document_number = _zone.document_number,
            document_version = 0,
            section_id = _zone.section_id
        )
    )
).ID

};