Answered

Showing Combo box Selected Items in a label

(0) Share

Report

Posted on by Community Power Pla...

Hello All,

I am creating a Request form and one of the required fields is a combo box so if the requester has more than one of the items.

Region Help.PNG

Region is the name of the Required field and the choices are coming from a SharePoint List. The code for the Combo Box is as so:

Choices('Training Requests'.Region)

That code works perfect, but its when I am trying to display the selected items onto the confirmation screen am I stuck.

Region Help2.PNG

I would usually put the code:

RegionInput.SelectedItems

but that does not work.

Would also like a comma between the choices in the text label

SharePoint list Name: Training Requests

Combo Box Name: RegionInput

Column that the combobox is retrieving the choices from: Region

Any help will be appreciated!,

Mono

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

mdevaney 29,989 Moderator on at

Like (1)

Report
@Anonymous

You can use this code to show the comma separated choices in a Text field. Make sure to change the column name "Value" to whatever your column name is.

Left( Concat(RegionInput.SelectedItems,Value,","), Len(Concat(RegionInput.SelectedItems,Value,",")-2 )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft on at

Like (8)

Report
Hi @Anonymous ,

Do you want to display the selected items value in a box?

1)If it is a label control.

Please set the label's Text:

Left( Concat(RegionInput.SelectedItems,Value&","), Len(Concat(RegionInput.SelectedItems,Value&","))-1)

// The comma is ",". Left and Len function is used to remove the last ","

2)If it is a list box

You could just set the listbox's Items:

RegionInput.SelectedItems,Value

Then the value will be separated to different lines automatically.

Best regards,

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

Like (0)

Report

@v-yutliu-msft

Thank You so much! That first code for the "text" for the label worked like a charm!

Best,
Mono

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

I was so close, LOL. We used the same code but it should have been -1 instead of -2.

Good to hear you solved the problem

Was this reply helpful? Yes No
Netrekar87 2 on at

Like (0)

Report

Need help cuz in the end after selecting Its showing builtin:icons in my form and database even though when selected in listbox Its Showing the same as the option Selected

Was this reply helpful? Yes No
CW 1,044 on at

Like (0)

Report
....SelectedItems,Value&"......
doesn't work. Anything after 'SelectedItems' gives red squiggly line error.

Was this reply helpful? Yes No
ShreyaSonawane1 5 on at

Like (0)

Report

OMGGGGG!!!! it was soooo helpful we were struggling from 3 months !!!!

Was this reply helpful? Yes No
sudosaurus 1,599 Super User 2024 Season 1 on at

Like (0)

Report

@v-yutliu-msft / @mdevaney

Any way to remove the trailing comma at the end?

Was this reply helpful? Yes No