Blank values from relevant are "" in AGOL but Null in ArcPro

DougBrowning — Thu, 18 Feb 2021 16:18:08 GMT

In the past the fact 123 uses "" and not null has been an issue. But now I am seeing that Pro is showing "" as Null somehow. I am looking directly at the hosted feature service in both. This actually means needing diff code in AGOL vs Pro to check for them.

In AGOL

In Pro

I am not seeing a domain or anything. How is this happening?

For Arcade will IsEmpty do it in both cases?

Thanks for any info

Re: Blank values from relevant are "" in AGOL but Null in ArcPro

XanderBakker — Thu, 18 Feb 2021 22:23:12 GMT

Hi @DougBrowning ,

IsEmpty will return true if the provided value is null or an empty string. So yes, it should be able to detect them both.

https://developers.arcgis.com/arcade/function-reference/logical_functions/#isempty

topic Blank values from relevant are "" in AGOL but Null in ArcPro in ArcGIS Survey123 Questions

Blank values from relevant are "" in AGOL but Null in ArcPro

Re: Blank values from relevant are "" in AGOL but Null in ArcPro