Intersect two feature layers in Experience Builder?

ZenMasterZeke

I have an Arcade expression in AGOL Experience Builder where I'm trying to intersect two layers: a point layer named sites and a polygon layer named counties. I want to get the count of counties that have a site in them.

I retrieve each layer using FeatureSetByPortalItem (since apparently ExB has no profile variables like $map) and include geometry. This works fine for both layers. But the code

var result = Count(Intersects(counties, sites));

 
gives the error "Test execution error: Execution error - Invalid parameter. Verify test data.". What is the problem here, and is there a way to fix or get around it? Thanks!

johnsonn35_MDHHS

@ZenMasterZeke, I assume you're using Arcade via the Data tab (not seeing FeatureSetByPortalItem as a usable function when e.g., adding a text widget, connecting it to data, etc.).

If so, I think the problem is that you're not returning a featureset? If you just add your data to a featureset (even though it's a featureset of 1 record), Experience Builder can then work with it.

This is messy but works. It counts the number of counties in Michigan that have at least one site on the National Register of Historic Places (76):

var counties = FeatureSetByPortalItem(Portal('https://www.arcgis.com'), '14c5450526a8430298b2fa74da12c2f4', 0, ['STATE_FIPS'], true)

var miCounties = Filter(counties, 'STATE_FIPS = \'26\'')

var sites = FeatureSetByPortalItem(Portal('https://www.arcgis.com'), 'd1073c2945cb4c6793136f51a97bdd8d', 0, [], true)

var newDict = {fields: [
    {name: 'Count', alias: 'Count of Counties with Sites', type: 'esriFieldTypeInteger'}
    ],
    geometryType: '',
    features: []
}

var countyCount = 0

for (var i in miCounties){

  var siteCount = Count(Intersects(i, sites))

  if (siteCount > 0){
    countyCount++
  }
}

Push(newDict['features'], {attributes: {Count: countyCount}})

var fs = FeatureSet(newDict)

return fs