topic Re: Need help with Arcade Expression in attribute rule that will grab a field value from another feature based on related fields in ArcGIS Pro Questions

Need help with Arcade Expression in attribute rule that will grab a field value from another feature based on related fields

GarySpenst — Fri, 17 Mar 2023 14:05:20 GMT

Hello,

I need help with Arcade expression. I have polygon layer and point layer that are related based on these fields: (Flush_number_trigger=Flush_number_trigger). Relationship is 1:1. In the polygon table, I'd like to return startvalve field value from related point layer Thank you in advance!

This is what I thought would work, but the startvalve value is not coming across.

Var FlushStart= featuresetbyname($datastore,'WAT_UnidirectionalFlushStarts',['startvalve','Flush_number_trigger'])

Var ref_flush=$feature.Flush_Number_trigger
Var Flushstart_filter= filter(FlushStart,"Flush_number_trigger=@Ref_Flush")

if(count(Flushstart_filter)>0){
return First(Flushstart_filter).StartValve
}
return Null

Re: Need help with Arcade Expression in attribute rule that will grab a field value from another feature based on related fields

DougMerrick — Wed, 22 Mar 2023 21:13:15 GMT

Hi,
I found success using the post below.

https://community.esri.com/t5/arcgis-pro-questions/attribute-rule-to-pass-a-value-from-parent-to/td-p/1123857

Re: Need help with Arcade Expression in attribute rule that will grab a field value from another feature based on related fields

GarySpenst — Wed, 22 Mar 2023 21:35:46 GMT

Thank you for the help!