Looking for the reverse geocode value to use in XLS

Hi, I tried multiple reverse geocode value(pulldata("@geopoint",${location},"reversegeocode"), pulldata("@geopoint",${location},"reversegeocode.address.Match_addr") in the Calculate field of my xls form, but there are I get no adresses or error message.

Hi, I suggest you read Understanding reverse geocoding in Survey123 3.0 in detail. In practice, every locator is different and the response uses different properties. .The key is to understand what the response looks like so you can execute your pulldata function on the right property.

The easiest way to look at the response is to simply use

pulldata("@geopoint",${location},"reversegeocode")

in the calculation of a text question. Make sure you make the appearance multiline and also set the esriFieldLength column to a crazy large number such as 20000. This is so the JSON response can fit within your text question. While in Connect you can test your survey and copy the JSON response for further analysis. I like to use https://jsonformatter.curiousconcept.com/ to make the JSON look friendly.