Xander Bakker thank you very much for all the help.
Here is the update from our conversation. I feel like I am soo close - Pro, during the edit, is complaining that a required keyword is missing, but near as I can tell I have them in there, I added the "attribute" from what I saw on a different blog post, but that doesn't appear to be it.
var tbl = FeatureSetByName($datastore,"GISLND.LAND.NonCustomerAddress");
var fc = FeatureSetByName($datastore,"GISLND.LAND.Premise");
var premiseKey = $feature["GlobalID"];
var nonCustomerSql = "GlobalID = @premiseKey";
var nonCustomerAddressPremise = Filter(tbl, nonCustomerSql);
for (var address in nonCustomerAddressPremise){
premiseKey = address.premiseguid;
}
var nonCustomerSql = "premiseguid = @premiseKey";
var nonCustomerAddress = Filter(tbl, nonCustomerSql);
var txt = "";
for (var address in nonCustomerAddress){
txt = txt + address.building_number + ',';
premiseKey = address.premiseguid;
}
var premiseSQL = "GlobalID = @premiseKey";
var premiseResult = Filter(fc, premiseSQL);
return {
"result": txt,
"edit":[{
"className": "Premise",
"updates" : [{
"attributes": [{
"labeltext": txt
}]
}]
}]
}