topic Re: Field not populating: Using pulldata from hosted table in ArcGIS Survey123 Questions

Field not populating: Using pulldata from hosted table

dsinha — Mon, 28 Jul 2025 18:24:26 GMT

Hello everyone,

I am trying to pull owner information from a hosted table (PropertyOwnerDetails) using the Parcel number (parcel_number in Parcels_Carlisle, map in PropertyOwnerDetails, both fields are String) as the common link. I have tried different solutions but just cannot get it to work. I do not get any error message - the field just remains blank.

Any help would be appreciated.

Thanks!

Re: Field not populating: Using pulldata from hosted table

Neal_t_k — Mon, 28 Jul 2025 18:59:41 GMT

Try to do a helper field with your where clause outside of your pulldata calculation

whcl: concat("map = ",${parcel_number})

and then put ...FeatureServer/0", ${whcl})

Calculations in side pulldata functions sometime cause issues

Re: Field not populating: Using pulldata from hosted table

dsinha — Mon, 28 Jul 2025 19:41:45 GMT

@Neal_t_k thanks for your help.

I tried your suggestion but it did not work:

Again, no error message.

Re: Field not populating: Using pulldata from hosted table

Neal_t_k — Mon, 28 Jul 2025 20:16:59 GMT

Just to rule it out, did you check that the rest url allow queries? and did you directly query the url to see if it works as expected?

Re: Field not populating: Using pulldata from hosted table

dsinha — Tue, 29 Jul 2025 16:19:18 GMT

Hello @Neal_t_k yes the REST url allows query.

And I was able to query the layer directly using steps shown here, and it worked without any problem.

Re: Field not populating: Using pulldata from hosted table

TylerGraham2 — Fri, 01 Aug 2025 16:15:18 GMT

Is the parcel number field actually a number field type (like an integer)? Our parcel numbers are stored as text. If it is a text field you need to enclose your parcel number in quotes. So your query builder field should look like:

concat("map='",${parcel_number},"'")

Re: Field not populating: Using pulldata from hosted table

dsinha — Tue, 05 Aug 2025 16:35:20 GMT

@TylerGraham2 you are absolutely right. That was indeed the solution that was offered by Esri tech support.

Additionally, we also realized that the table I was trying to pull the records from had around 700+ values in the join field (parcel number) that was formatted differently (and extra "-"). I was sitting inside one of those parcels whose ID was formatted incorrectly while I tested the app. So no records were returned during my tests. 🙄

Thank you all!