ComboBox SelectedItems object to text

[Anonymous]

Hi all,

Sorry if this is a stupid question but i am struggling to find the documentation to turn the item in a combobox into text. It's set so that only one item can every be selected a time. 

How do i turn the output from an object to text so that i can use it in a table?

Collect(Info, 
 {
  Kit:KitValue,
  Workbook:Text(ComboBox3.SelectedItems), 
  Worksheet:Dropdown1.Selected.Value,
  Information:TextInput1.Text
}
);

It is the workbook line that doesn't work however i'm looking for a command to do that sort of thing.

Kind regards,

Colleen

[Mike8 · Accepted solution]

Hello Colleen,

Can you try to change the 4th line of the expression to:
Workbook:Text(ComboBox3.Selected.NameOfTheColumn) 

Instead of SelectedItems you need to write Selected.NameOfTheColumn

[Anonymous]

Brilliant, this was what i needed! Thanks @Mike8 🙂

[IanMcK]

Hi Mike,

Do you know how to do the same for multiselect; e.g: ComboBox3.SelectedItems.NameOfTheColumn

I'm trying to insert multiple rows into a Sharepoint List:

* Define variables e.g. Var1 = a, Var2 = b, Var3 = c

* Select multiple options from ComboBox (VarCombo) e.g. x, y & x

* Insert multiple rows into a Sharepoint list based on the above e.g.

    VarCombo   Var1   Var2   Var3

1          x              a         b        c

2          y              a         b        c

3          z              a         b        c

I've got close by using a ForAll, but will still only return one of the SelectedValues.

    VarCombo   Var1   Var2   Var3

1          z              a         b        c

2          z              a         b        c

3          z              a         b        c

Any help appriciated!! 

Thanks,

Ian

[Mike8]

Hello,


Yes, we can make it work. Here is an example.

If you have a collection
Button1.OnSelect = Collect(Collection1,{Column1:"A"},{Column1:"B"},{Column1:"C"})
CompoBox1.Items = Collection1
Button2.OnSelect = ForAll(ComboBox1.SelectedItems,Collect(Collection2,{ColumnName1:Column1}))
So Collection2 is your sharepoint list and ColumnName1 is the column in the sharepoint list you would like to write the values from the compobox.

If you use this example as a reference I think you can make it work. Else,let me know if you have an issue please

[IanMcK]

Hi Mike,

I think I'm almost there! Although I'm afriad I don't understrand the requirement for two buttons, and how to get the CombiBox Items in the final collection e.g. Button2.OnSelect = ForAll(ComboBox1.SelectedItems,Collect(Collection2,{ColumnName1:Column1, ColumName2: ComboBox1.SelectedItems.Value}))

Have I understood this right?

Button1.OnSelect = Collect(Collection1,{Column1:"A"},{Column1:"B"},{Column1:"C"}) - This button collects the Variables
CompoBox1.Items = Collection1 - I'm not sure where this goes?
Button2.OnSelect = ForAll(ComboBox1.SelectedItems,Collect(Collection2,{ColumnName1:Column1})) - This inserts the Variables into the Sharepoint list (although I can't see how to insert the ComboBox Values?

[Mike8]

I am sorry, I could have explained better.
Button1 and CompoBox1 in my example are there to help me use Button2.
Button2.OnSelect expression is important for you to understand how it works.
Button1 creates a dummy collection and I use it as CompoBoxItems.

Lets go to your case..

I'm trying to insert multiple rows into a Sharepoint List:

* Define variables e.g. Var1 = a, Var2 = b, Var3 = c   --- (I suppose these are constants)

* Select multiple options from ComboBox (VarCombo) e.g. x, y & x --- (I suppose that VarCombo is the name of the Compobox and DisplayedComboBoxColumn is the name of the displayed column in the combobox)

* Insert multiple rows into a Sharepoint list based on the above e.g. ---(I don't know the name of the sharepoint list and the columns of the sharepoint list you want to write your values to, so I will use List and the columns of the sharepoint list ListColumn1-4)

Button2.OnSelect = ForAll(VarCombo.SelectedItems,Collect(List,{ListColumn1:Var1,ListColumn2:Var2,ListColumn3:Var3,ListColumn4: DisplayedComboBoxColumn })) 

You need to change List,ListColumn1,ListColumn2,ListColumn3,ListColumn4,DisplayedComboBoxColumn, to the actual names that you use in your app

[IanMcK]

Here's a screenshot showing what I have currently, as unfortunaly I'm still not able to get it to work;

ForAll(ComboBox.SelectedItems,Collect('List1',{Column1: Var1.Text,Column2: Var2.Text,Column3: Var3.Text,Column4: ComboBox.Selected.Value}))  - Image 1 Below

- This only returns the last item in the CombiBox

ForAll(ComboBox.SelectedItems,Collect('List1',{Column1: Var1.Text,Column2: Var2.Text,Column3: Var3.Text,Column4: ComboBox.SelectedItems.Value}))  - Image 2 Below

- This returns [objectObject] for each item

Thanks for your help! Nearly there by the looks of it!!

Ian

[Mike8]

Hello Ian, 🙂

Yes, you are so close..
ForAll(ComboBox.SelectedItems,Collect('List1',{Column1: Var1.Text,Column2: Var2.Text,Column3: Var3.Text,Column4: ComboBox.Selected.Value}))

You have set the Column4 to ComboBox.Selected.Value. You need to change it and assign the DisplayedComboBoxColumn to Column4.
What I mean is..
CompoBox has a table as a source. I don't know the name of the source. It can be a collection or a list or whatever.
Let's name the source of the Compobox, Collection1.
Collection1 is a table and has columns. You can see the items, of Collection1 from a specific column, in the Compobox. I named that column DisplayedComboBoxColumn. So, 
ForAll(ComboBox.SelectedItems,Collect('List1',{Column1: Var1.Text,Column2: Var2.Text,Column3: Var3.Text,Column4: DisplayedComboBoxColumn})

If you still have issues, can you please provide the source of your compobox and its structure?

[IanMcK]

Hi Mike,

Thanks again for the reply and help! So close, but yet so far!!

CombiBox Source = Collecton name "Set1" with two Columns "Column 1" & "Column 2"

This created the Collection "Set1" - ClearCollect(Set1, {Column1: "1", Column2:"x"}, {Column1: "2",Column2:"y"} ,{Column1: "3",Column2:"z"})

ComboBox.Items = Set1.Column2

Button 2 = Clear('List1') ; ForAll(ComboBox.SelectedItems,Collect('List1',{Column1:Var1.Text,Column2:Var2.Text,Column3:Var3.Text,Column4:Set1.Column2}))

Returns: [object Object],[object Object],[object Object] (Screenshot 3 - attahced)

Using a lookup returns the last value in the SelectedItems only: (Screenshot 4 - attahced)

Button 2 = Clear('List1') ; ForAll(ComboBox.SelectedItems,Collect('List1',{Column1:Var1.Text,Column2:Var2.Text,Column3:Var3.Text,Column4:LookUp(Set1,Column2 = ComboBox.Selected.Column2,Column2)}))

Thanks again for your help!

Ian