Formula Asssistance

[Tango]

Hi,

I have a single choice combo box with a datasource of Sharepoint list that displays the title

In addition I have a toggle with values of Off and On

I am trying to populate a multi line text input with the contents of the selected item in the combobox when a selection is made.

I also need to concatenate some text if the toggle is in the on position.

My attempt so far is in the Default value of the textbox is

If(Toggle1.Value,"Off",Combobox1_3.Selected.Title,Concatenate("AB: ",Combobox1_3.Selected.Title))

Thanks in advance for any assistance.

Todd

[EddieE]

@Tango 

You are close, try this

If(
   !Toggle1.Value,
   Combobox1_3.Selected.Title,
   Concatenate("AB: ",Combobox1_3.Selected.Title)
)

[cha_cha]

Hello @Tango 

Try these two codes

If(Toggle1.Value,"Off",Concat(Combobox1_3.SelectedItems,Title,","))



If(Toggle1.Value,"Off",
	Concat(
		AddColumns(
			Combobox1_3.SelectedItems,
			"ExtraTexts","AB: " & Title & "
"
		),
		ExtraTexts,","
	)
)

[Tango]

the function if has some invalid arguments

the function concatenate has some invalid arguments

[Tango]

the function concat has some invalid arguments

name isn't valid ExtraTexts isn't recognised

[EddieE]

@Tango 

Ooops, sorry you are using a Combobox - I just assumed your code worked. Try this

If(
   !Toggle1.Value,
   First(Combobox1_3.SelectedItems).Title,
   Concatenate("AB: ", First(Combobox1_3.SelectedItems).Title)
)

[Tango]

same error messages

[Tango]

Actually

the function if has some invalid arguments

Invalid use of '.'

the function first has some invalid arguments

in addition, the combobox doesn't even have a coloured box around it

[Tango]

These both works on their own

Combobox1_3.Selected.Title

Concatenate("AB: ", Combobox1_3.Selected.Title)

[Tango]

also just noticed that the output on the toggle whilst it says on or off is showing false or true