Table won't load in Field Maps Arcade -- error Code = 3072

Question

Cannot load table according to Field Maps app log, I'm pretty sure my code is fine.. what am I missing? I can see the table in the Arcade editor in FM Designer. "Can only call this method on a loaded table...............Table () failed to load with error: Error Domain=NSCocoaErrorDomain Code=3072 "User canceled error"

if (!IsEmpty($feature.scientificname) && !IsEmpty($feature.survey_area)) {

var sciName = $feature.scientificname
  var surveyArea = $feature.survey_area

var priorityTable = FeatureSetById($map, "my_table_ID_#");
  var filtered = Filter(priorityTable, "botanical_name = @sciName AND zone = @surveyArea");
  if (!IsEmpty(filtered)) {
    return First(filtered).apa_priority
  } else {
    return "no cat found"
  }

} else {
  return "uncat"
}

error.txt

Feature-table-font-size.png

EmmaHatcher_0-1619627313752.png

dougbrowning · Accepted Answer

My only guess then is the AND in the filter as I can find no examples of this.  Do a test without the and just to see.

nate0102 · Accepted Answer

Hi @DougBrowning ,

Thanks for your suggestions!

ESRI support figured out a work around:

Move the First() to line 7 instead of 9 like so:

var filtered = First(Filter(priorityTable, "botanical_name = @sciName AND zone = @surveyArea"));

They unfortunately couldn't figure out why this code worked as opposed to the other code.

Hope this helps someone in the future...