Updating Multi Select List

(0) Share

Report

Posted on by NPrice99

1,302

I have a SharePoint list called countries which consists of two site columns :-

TwoLetterAcronym and NameOfCountry.

I want the user to be able to select more than one NameOfCountry and for the corresponding columns TwoLetterAcronym to be saved and seperated by "," in a Text Field.

Similarily, When the Form is dispalyed, I want to be able to to take the list of TwoLetterAcroynms (seperated by the ",") and for the corresponding NameOfCountry(s) to be displayed in the Multi-Select Combo box.

How can I do this ? I can save the TwoLetterAcronyms in a hiddent text field and then concat the selected values in the combo box and ","into the hidden text field and then save that to a SharePoint Text field, but how do I reverse the process so that the TwoLetterAcronyms become a set of Country Names in the Combobox ?

Thanks

Nigel

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-monli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @NigelP,

First of all, sorry but I really didn't fully understand what you want to achieve according to your description. Please help to answer a few questions:

1. What is the column types and settings of these 2 columns? Are they both text columns? If any of them are Choice columns, are multiple-select enabled for these columns?

2. My understanding is that both columns are text fields. If so, then by default there should be no options for these columns when using an edit form to update the item. Then about "I want the user to be able to select more than one NameOfCountry and for the corresponding columns TwoLetterAcronym to be saved and seperated by "," in a Text Field." :

By "select", did you mean that you will use a dropdown control and set some selectable options for users to pick and save to the text field?

About your last question, I guess the general situation is like:

TwoLetterAcronyms:

AB,CD,EF,GH

And you want these textes to be displayed in combo box as separated selected values.

Then you could try to set the DefaultSelectedItems property of the combo box to:

Split(Label1.Text,",")

Regards,

Mona

Was this reply helpful? Yes No
NPrice99 1,302 on at

Like (0)

Report
Copy link

Link copied!

Hi Mona

Thanks for responding.

The two columns in the list are both Text fields, one column is the country name and the second is the two letter acronym corresponding to the country name..

There will be no option to update either field. The list is just a read-only list.

So there will be a combo box which, when you click or start to enter the name of a country, will present a list of country names. The user then selects one or more countries and the process is repeated. The selected countries will appear in the combo box, they can then repeat the process and select other countries. SO that at the end of the process, there will be a list of countries in the combo box. When the foirm is saved, the Two Letter acronyms corresponding to the displayed countries are saved in the text field. So the next time the form is displayed it will display the country names of the two letter acronyms in the saved in the text field.

Regards

Nigel

Was this reply helpful? Yes No