Making a field visible based on the values in Multi selection field

[PowerUser19]

I am working on visitor request application. 

The departments the visitors are planning to visit are chosen from the check boxes in MS form. The data is then written in SharePoint List. As the sharepoint list is updated via power automate, the field has square brackets by default. 

I am making a field visible based on the value selected in he multi selected field.

If("Design" in VisitingAreaUpdateRequest.SelectedItems.Value || "Fabrication" in VisitingAreaUpdateRequest.SelectedItems.Value || "CAD" in VisitingAreaUpdateRequest.SelectedItems.Value,true,false)

Sharepoint list value has ["Design",Fabrication","CAD]

I want to make the people search field visible based on the departments chosen. If I choose the departments in the PowerApps form, I am able to see the respective manager (people search) field. But with the default data in the list, the manager field is not visible. I think it is because of the square brackets. I am not sure what is the best way to achieve this. Any help is highly appreciated. Thank you in advance.

[WarrenBelz]

@PowerUser19 

OK we need to re-group here as this should be a simple solution as long as I get the correct values - so from your posts VisitingAreaUpdateRequest is a multi-select Combo Box - what is the name and type of field it is writing to in SharePoint ?

[PowerUser19]

@WarrenBelz  Really appreciate your time and help on this.  In SharePoint it is a Choice column with Multi select enabled. The name of the field is "Visiting Area"

[PowerUser19]

@WarrenBelz  I also tried to concat and display the value of Visiting Area field in a label to see if I can then separate them to identify the text that I am searching for by using the below code in the label, 
Concat(VisitingAreaUpdateRequest.SelectedItems.Value, ", ")
The label only displayed the comma ","

[WarrenBelz]

@PowerUser19 ,

OK, please be specific with your responses if you can - when you say "does not work" do you mean it produces an error or you do not get the results you expect

You also need

Concat(
   VisitingAreaUpdateRequest.SelectedItems,
   Value, 
   ", "
)

Also is the Items of the Combo Box simply

 Choices(SPListName.'Visiting Area')

[PowerUser19]

Sure I will. 
Yes below is the items property of the combo box.

[PowerUser19]

Now I am able to see the values in the label after I corrected the formula. Thank you. 
I noticed the below. The items that are already selected in the Combo box are within Square brackets and the condition that I use to display the control did not work - Not visible. Also the Combo box is allowing me to select the same option again - after which the control becomes visible. In the example below the first option "Toyota Design Australia - Studio" is already selected in the Combo box (within square brackets). When I try to make changes and select the same option again, it adds it at the end after the square brackets. So anything within the square brackets are not recognised?? 

[WarrenBelz]

@PowerUser19 ,

OK I have done some testing as I was starting to doubt myself and to confirm my comment on the first post - this is strange as your original formula should work and my testing has confirmed this. Put that aside for the moment and this

"Toyota Design Australia - Studio" in ThisItem.'Visiting Area'.Value ||
"Toyota Design Australia - Fabrication" in ThisItem.'Visiting Area'.Value ||
"Toyota Design Australia - Indoor viewing" in ThisItem.'Visiting Area'.Value

also has to work first time (without selecting anything) providing: -

• one of those values are in the choices stored in SharePoint AND
• the object you want to hide is in the same form as the Combo Box AND
• you are not getting an error with the formula

I am not sure what more to offer other than testing by putting another control (an icon will do) in any data card in the form with the same formula and see if that is visible when required.

[PowerUser19]

@WarrenBelz  I understand. Yes it is strange! I have used the similar code to display different control which has worked but not this. There must be something wrong! 
1. Yes, one of the values are stored in SharePoint list
2. Yes the object is in the same form as the ComboBox! 
3. No error but the control is not visible. 

I will try to refresh data set and take a break and come back to this to see what is missing. Thanks for you help again! 

[WarrenBelz]

@PowerUser19 ,

Where are you based ? We might be able to do a quick Teams tomorrow as we are going in circles a bit here.

[PowerUser19]

That's a great idea. Melbourne Australia!