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
a
(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
a
(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
a
(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
a
(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
a
(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
a
(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
a
(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
a
(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
a
(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
a
(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