Arcade help - Return "Not Available" when no values exist

05-17-2021 01:03 PM
Labels (2)
Occasional Contributor

This is a bit of a follow up to this post:

Solved: Re: Removing blank values via Arcade Expression - Esri Community

I now have the comma separated lists working with blank values removed. However, for entries where no appropriate company exists for that entry, I would like to return "Not Available" instead of simply leaving the value blank.

Here's what it currently looks like:


The blank spot next to "System Installer" is what I would like to have say "Not Available" if there are no matches.

Currently, the field is set up like so (this is the same way for Supplier/Owners):


This works perfectly when there are existing values for this entry in the map series. However, for entries that do not have a matching ROLE_ID I can't figure out how to return "Not Available" instead of just leaving it blank.

I don't feel like I'm explaining this particularly well either, so please feel free to ask more pointed questions to help figure out the root of the issue.

0 Kudos
1 Reply
New Contributor III

I would try something like IIf(IsEmpty(ROLE_ID),'Not Available',$feature.ROLE_ID)