how to fix the error for switch function

[freshyshreya]

Hi,

In the pic below,I am trying to use switch function(2) based upon the selection made in (1)

Note:1 is a combo-box

2 is a label

The below pic shows the error

Please help!

[PG_WorXz10]

Hi @freshyshreya ,

Could you please share the code. It seems there is something wrong in the code and it is returning table values to the label.

[freshyshreya]

Hi @PG_WorXz10 ,

Sharing the code in the pic below.

[PG_WorXz10]

Hi @freshyshreya ,

Do you want to display the text in square brackets ? 

[PG_WorXz10 · Accepted solution]

Hi @freshyshreya ,

If you want to print the values in text format you can use below formula and update according to your requirement. 

Switch(ComboBox2.Selected.Value,"Finance",Concatenate("[","freshy","]"),.....)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[freshyshreya]

Hi @PG_WorXz10 ,

No,I don't want to display the text in square brackets.It should be normal text like freshy,rajesh,aravind etc

[PG_WorXz10]

Hi @freshyshreya ,

In that case please try below formula because powerapps consider [ ] for array thats why it is resulting in records value. 

Switch(ComboBox2.Selected.Value,"Finance","freshy",.....)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[freshyshreya]

Hi @PG_WorXz10 ,

The solution works.Thanks!