fetch attribute from table

dsinha

Hello, 

I have a data collection layer for FieldMaps and a table stored on the Portal. Based on the Parcel ID on the data collection layer, I am trying to populate the owner address in the collection layer from the table. I am basing the Arcade expression on this post.

var OwnerAdd = $feature.ma
var table = FeatureSetByPortalItem(Portal('https://xyz/portal/'),'61fe20149cd74fff91209b580f841145', ['parcelid', 'owner'])
var filteredTable = Filter(table, "parcelid = @OwnerAdd")
var result = First (filteredTable)
if(!IsEmpty(result)){
  return result.owner
}

When I test it , it provides a null output and it does not work in the form.

Any help would be appreciated. 

dsinha

Thanks for your suggestions @DougBrowning & @JamesMiller36. I did check to make sure that all the data types are same (both parcelid and pn are string). However, it seems that I did not understand how the arcade expression works.

Based on what you said @JamesMiller36, I realized that I had to change the first line of the code to say 

var OwnerAdd = $feature.pn

And it worked!

Thanks again!