Answered

Combobox Multiselect not reflecting in sharepoint list form

(1) Share

Report

Posted on by rohitsekar1996

Hi guys,

I have been trying to create a user form. I have Combo box field with multi-select named Portfolio_input . Items for the combo-box field gets data from another share-point list named REGION_COUNTRY. I am able to multi-select items in combo-box but the selected data is not reflecting in final user-form list. and I want the selected data to be separated by either comma(,) or semicolon(;) in final user-form list.

pic 1

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report

You have to use a concat formula to accomplish what you are trying to do. Add a label to your app and set it's text property to the concat formula. You will then patch the label content to your sharepoint list

Concat(comboboxname.SelectedItems, ColumnName & ", ")

Here is my example:

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

Hi @rohitsekar1996

A few things come to mind that should be checked 🙂

What happens when you submit - is it that it stores only the first value or is it storing no value at all?

Is your PORTFOLIO_INPUT column a choice type? ..and if yes, then has it been set to allow manual entry?

If its not set to allow manual entry it will only allow entry of items that it has options for.

Is the Update value of the Datacard in the form set to YourDropdownName.SelectedItems ?

Cheers,

Sancho

Was this reply helpful? Yes No
rohitsekar1996 58 on at

Like (0)

Report

thanks for the reply,
1. It stores last selected value.
2. Yes, it is a Choice Type Manual entry is restricted.
3.No, My Update Property is not set to Dropdownvalue.SelectedItems but i tried setting it as DropdownValue.SelectedItems i am getting error "expecting Text"

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

Excellent, thanks for getting back to me - ok, so its possible that column may have been text previously? and then when changed to choice column it didn't pick up the change, I have had this happen before many times so I'm thinking it definitely might be that.

I'd remove the Datacard, restart the whole browser tab from scratch so that no cached values are kept, and then re-edit the form and re-add it again:

We can now see after closing down the editor and the browser tab, that if we go back in and try to add the type, it picks up the correct type (multi-choice):

In terms of it being a choice field without manual entry (at the data source end) - you can't submit a value that's not listed in the column's properties unless manual entry in allowed - what I would usually do in this case is stop the App from allowing manual entry, but keep the data source allowing manual entry - that way your App can continue to use the items from the other list without the user being able to add any of their own.

Cheers,

Sancho

Was this reply helpful? Yes No
rohitsekar1996 58 on at

Like (0)

Report

Thanks for the suggestion,
Concat(comboboxname.SelectedItems, ColumnName & ", ") can you explain the ColumnName in this formula which ColumnName you are referring to. And can you explain how to Patch the label content to share-point list.

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report

The column name is the name of the column in your combobox data source. In my case in the example I gave, my data source is a SharePoint list and the column I am using in the combobox is the Title column.

I was a little hasty in my initial reply in that I didn't get any additional information from you. This only works if you are patching the information to a multi-line or single line of text column.

Patch(SharePointList, Defaults(SharePointList), {TextColumn: Label.Text})

SharePoint list is your sharepoint list you are saving the data to
TextColumn is the column you are patching with the label data
Label.Text is the label where your concat formula is. You patch the .text property to the list.

Was this reply helpful? Yes No
v-yutliu-msft on at

Like (0)

Report
Hi @rohitsekar1996 ,

Have your issue been solved?

If not, let me make a conclusion:

Do you want to use combo box to update your multiple choice type field and display data by separator ","?

Could you tell me:
1) are you sure you use combo box or drop down? drop down does not have "selecteditems".

2)where does the combo box's Items come from? this choice field's choice?

3)what data type of this field? choice type field will not show "expecting Text".

4)the field's settings, the combo box's Items?

Please notice that: value in combo box could not display by separator ",".

1)If it is a text type, you could set the datacard's Update:

Concat(combo boxname.SelectedItems,fieldname&",")

2)If it is a multiple choice type, you could set the datacard's Update:

comboboxname.SelectedItems

//combo box will not display data by separator ",", you could insert a label to display data.

set the label's Text:

Concat(ThisItem.fieldname,Value&",")

Best regards,

Was this reply helpful? Yes No
Verified answer

rohitsekar1996 58 on at

Like (0)

Report
Thanks for the Reply, Issue has been solved by placing below formula in the PORTFOLIO_INPUT update property.
Concat(DataCardValue4.SelectedItems, Result & ";")

Was this reply helpful? Yes No