topic Re: Arcade Expression !IsEmpty not Functioning Correctly in ArcGIS Online Questions

Arcade Expression !IsEmpty not Functioning Correctly

a_bakiera — Mon, 19 May 2025 18:47:17 GMT

Hello. I have an Arcade expression in ArcGIS Online that I believe is not working correctly. It is listed below

var VisualNoWorkNeeded = DomainName($feature,"PEC_Status") == "Visual No Work Needed"

var isCompleted = DomainName($feature,"No_Access_Reason") == "Completed"

var NoAccess = DomainName($feature, "No_Access_Reason") == "Other" ||

DomainName($feature, "No_Access_Reason") == "Locked Gate" ||

DomainName($feature, "No_Access_Reason") == "Landowner Refusal" ||

DomainName($feature, "No_Access_Reason") == "Animals"

var auditAccepted = DomainName($feature,"PEC_Status") == "Accepted"; // Accepted Not Accepted

var auditNotAccepted = DomainName($feature,"PEC_Status") == "Not Accepted";

var hasWorkOrder = !IsEmpty($feature["WorkOrderNumber"]); // string

var Assigned = !IsEmpty("");

var B = $feature["Veg_Score"] == "B"; // B C

var C = $feature["Veg_Score"] == "C";

var vegScore = $feature.Veg_Score; // C B

return When(

auditNotAccepted, "Audit Not Accepted",

auditAccepted, "Audit Accepted",

VisualNoWorkNeeded, "Visual No Work Needed",

isCompleted, "Work completed",

NoAccess, "Unable to Access",

hasWorkOrder, "Work order",

Assigned, "Work assigned",

B, "B",

C, "C",

vegScore

)

The problem is occurring with the part that is in bold. I am trying to get the expression to say "work order" when one exists. Right now, there are no work orders in the data and yet, every single entry is coming back with that value. I'm fairly confident that part is the problem because if I comment it out, the expression works correctly. I get the same result if I type that line like this:

var hasWorkOrder = !IsEmpty($feature.WorkOrderNumber); // string

Re: Arcade Expression !IsEmpty not Functioning Correctly

RyanUthoff — Mon, 19 May 2025 19:16:05 GMT

Is the data in the WorkOrder Number field truly a null value? Or could it just be an empty string with a space or something like that? As a quick test, you could try returning the value of the WorkOrderNumber variable in the Arcade expression, just to see what it is saying the value is.

Re: Arcade Expression !IsEmpty not Functioning Correctly

a_bakiera — Mon, 19 May 2025 20:03:37 GMT

Here is what I got

Re: Arcade Expression !IsEmpty not Functioning Correctly

RyanUthoff — Mon, 19 May 2025 20:26:50 GMT

Yeah, your records aren't truly null. It looks like it is just an empty string, or a value of a single space or something. If it was truly null, it would look like this:

So your Arcade expression is working correctly, you'll just need to either correct the data to make the values truly null, or you'll need to account for empty strings/spaces in your Arcade expression.

Re: Arcade Expression !IsEmpty not Functioning Correctly

a_bakiera — Mon, 19 May 2025 21:43:04 GMT

Ok good deal. Thank you for catching that. I ended up nulling the records and that solved the problem!