S123 Form Clickable Map NOT working to return attribute from a polygon

Question

I CAN get the Map to show in the S123 Form, however when I zoom to the polygon and click it (make a polygon from the point FL just to attempt that too), it does NOT return the attribute from the Calculation cell in the XLS.  Below is a brief description of what I have tried along with the XLS for review. (XLS highlighted in Yellow the rows of interest.)

Background here: I WAS able to use "another" XLS to have it create the Web Map which I configured a Pop-up with a parameter URL so I could Click a point (not a polygon) and it would return that point (attribute) to the S123 Form.  All good there. However, I want the field crew to be able to do all this just from the S123 Form so...

WHAT I NEED is to have a Map IN the S123 Form that is 'Clickable' and will return the attribute automatically without any human error in the field. (FYI, I changed the Feature Layer from point to a polygon in hopes that would work; nope. Also, I had many other versions of this same XLS with different approaches and landed on this approach (see attachment and Esri links) which appeared to be the best solution.  The Map DOES show up in the Form and I can zoom in and Click the polygon (even at full zoom) but nothing is returned in the Form.  😞

I attached the final XLS that I am using as well as the links below which I watched and followed, as well as I did extensive research in the Esri Community and beyond.

ANY HELP you can give me would be great!

Thanks! - Teresa

LINK to Esri video that helped for pulldata with spatial map in Form.

LINK to Esri document they reference in that video.

Manhole-Inspection_20250710-a.xlsx

Neal_t_k · Accepted Answer

The layer you are trying to pulldata from is a point layer, so unless they click the exact right spot you are not going to get a response,  I am not sure if this will even work for a point layer.  You mentioned making a polygon layer from the point layer, have you tried referencing that layer instead of the point layer?

Another option would be to configure the query to search within a distance of your location.

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-pulldata-quot-layer/ba-p/1224415

Again not sure how this will work with a point layer.

Neal_t_k · Accepted Answer

This works, but it is a very big search radius, and I don't know which point it is returning, the closest, or more likely the first in the list. You could play with this shrinking the search radius until you are happy.

pulldata("@layer", "getValueAt", "attributes.mw_manh_24", "https://maranaegov.com/server/rest/services/Hosted/MW_MANHOLES_2025/FeatureServer/0?distance=1600&units=esriSRUnit_Foot", ${location})

or, If it were me I would make a polygon layer (similar to a parcel layer) where each polygon has one manhole attributed to it and use that instead of your current point layer for the pulldata query.

Neal_t_k · Accepted Answer

You need something like this for your pulldata to reference

In ArcPro:

Create a border for your area of interest.

From your point layer, use the Create Thiessen Polygon tool (output fields - All) to make polygons

Clip the Thiessen Polygons to your border layer.

Publish the resulting feature layer and use that feature for the pulldata query.

Teresa-AZ · Accepted Answer

Hi Neal - I created a 10-meter circle for them to Click and I have to be careful since I do not want it to overlap on other manhole covers.  I will add in the distance code, as you did, to hopefully be able to get it to work.

Hi abureaux - I was able to do that and it was successful, however I wish for them to only use the S123 app and therein lies my problem.

I will attempt what Neal suggested since that "seems" like it would work for us and I see his image with it working.

I will let everyone know what happens here. THANKS!  - T

Teresa-AZ · Accepted Answer

IT WORKED!  Thanks!

Neal, you are the Best!