Arcade IIF statement not working

[tendtreesTC]

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 solution]

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');

[tendtreesTC]

that worked great thank you