Answered

ComboBox SelectedItems object to text

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

Sort by

Verified answer

Mike8 1,330 on at

Like (2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
IanMcK 18 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Mike8 1,330 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
IanMcK 18 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Mike8 1,330 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
IanMcK 18 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Mike8 1,330 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
IanMcK 18 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Mike8 1,330 on at

Like (1)

Report
Copy link

Link copied!

Button 2 = Clear('List1') ; ForAll(ComboBox.SelectedItems,Collect('List1',{Column1:Var1.Text,Column2:Var2.Text,Column3:Var3.Text,Column4: Column2}))
________________________________
I changed Set1.Column2 to Column2
Please let me know 🙂

Was this reply helpful? Yes No