Visibility based on whether multiple choice column contains specific multiple values

[Leu0101]

I was trying to make a label's visibility false if my multiple choice column  "BidStatus" value contained finalizing, create quote, or funding value. However it doesnt not seem to work using this code: 

If(SelectedTicket.BidStatus.Value = "Finalizing" || "Create Quote" || "Funding", false ,true)

Is there another way I should be coding or looking at this?

Thanks for the help!

[Anonymous · Accepted solution]

@Leu0101 

Unfortunately, you need to write this code out in full, ie

If(
   SelectedTicket.BidStatus.Value = "Finalizing" || 
   SelectedTicket.BidStatus.Value = "Create Quote" || 
   SelectedTicket.BidStatus.Value = "Funding", 
   false,
   true
)

[v-jefferni]

Hi @Leu0101 ,

Since it is a choices column that allows multiple selection, the selected values are actually in a table. As per your goal, you will need to change the formula to:

If( "Finalizing" in SelectedTicket.BidStatus.Value || "Create Quote" in SelectedTicket.BidStatus.Value || "Funding" in SelectedTicket.BidStatus.Value , false ,true)

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[Leu0101]

Thanks for the information! Good to know!