IF statement on CHOICE column from SharePoint

[Data_Enthusiast]

Hi Power Apps Community,

I am trying to perform an IF statement based on a SharePoint field - which is a CHOICE type.

Based on what I use below, I get an error: "Invalid argument type". Not sure what I am missing.

If(CollectionName.Field = "Not Available", "No", "Yes")

Note: the SharePoint list is being stored in a Collection.

I would really appreciate any help.

Thank you in advance.

[VijayTailor · Accepted solution]

Hi @Data_Enthusiast ,

You are using collection in If condition, 
The collection is basically Table Type. So for validation, you need to Get the value that you want to validate.

See below - in the below example I am using FirstN and Last that give me my value that is Combobox type and validation with value.

If(Last(FirstN(TestAk,1).Complexity).Complexity.Value="Transfer to future date","Yes","No")

Thanks,

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay

[Data_Enthusiast]

@VijayTailor 

Thank you! This worked perfectly 😀