Arcade IIF statement not working

Question

Hi there,

I am trying to use an IIF calculation to determine whether a switch should be selected to 'yes' or 'no' based on a field in the parent data.

When I use the following calculation:

Features = FeatureSetByRelationshipName($feature, 'WCC_Hort_Site_Auditing_XV2X_inspection_audit');

the result is

However, when I try to input this into an IIF statement:

iif(FeatureSetByRelationshipName($feature, 'WCC_Hort_Site_Auditing_XV2X_inspection_audit',['bedding'])=='yes','yes','no') it returns "no" I imagine it is something to do with the return being a featureSet rather than a straight yes/no Can anyone help me with this calculation? Thank you

kenbuja · Accepted Answer

You're correct in your thinking that it's a question of improperly evaluating a FeatureSet. You have to get a Feature from that FeatureSet to do that. If you're expecting only item to be in the FeatureSet, use First to get that feature and perform your evaluation.

var fs = FeatureSetByRelationshipName($feature, 'WCC_Hort_Site_Auditing_XV2X_inspection_audit');
var feat = First(fs);
iif(feat['bedding']=='yes','yes','no');