Cannot see other added layers when using Calculating Expressions in Field Maps

[RishV-B]

Hi,

I am working on Field Maps form (layer is not hosted/through server) and need to add a simple expression to auto-populate some fields from another layer that is also added, using FeaturSetByRelationshipName . 

I know how it's all done with the hosted layer in AGOL. However, I do not see some options here from our portal. For some reason, my second layer isn't in the Globals. Naturally, my expression fails because it can't see the feature. I also don't have Relate Records option available either.  

Would appreciate your help to figure out why I can't see other layers in Globals in my current setup. 

p/s our version E is 10.9

Just to be clear, I did search through community before posting but didn't find anything that would relate to my issue.  

Thanks!

[RishV-B · Accepted solution]

I've figured out the solution to my problem. I thought I would post it here in case anyone has a similar case.

My setup: SDE-->Portal, not hosted layer, and layers cannot be in the same geodatabase.

The only way to pull the attribute values from one (polygon) layer into another (point) attribute is to use Intersects($feature, $feature).

One small exception: in FeatureSetByName($map, "", ["field"], true) instead of $feature.

Works perfectly with pretty much any layer!