Add value to selection column in a SharePoint

[Amatrox]

Hi all,

I´m trying to figure out, how to update a selection column in a SharePoint. Let me explain my needs in a demo:

1. We have a list, which contains all locations (Countries) of my company: 

2. We have a document libary which contains GDPR documents with a country column, to allocate a document to one or more countries:

The country column looks like this:

Now I need a solution for the following:

If my company opens a new store in a new country, I need to have this country in the list and as a selection for the country column in the docuemnt libary. 

My plan was the following: Add a new country to the "country" list. The flow automatically adds the new country as a new selection in the "country" column in the document libary. Background is, that we want just one place to add the country and not at two.

Hope you can understand my problem and may have a solution for me 🙂

Cheers,

André

[ekarim2020 · Accepted solution]

This can be accomplished by using another SharePoint list to store the country list.  Your GDPR Documents Library's Country field can then lookup the values for country from the country list. This will allow you to add or remove countries from the Country list without needing to modify the flow.

Below is an example of a Contracts Library that uses a currency field. The currency values are not stored in the Contracts Library. The currency values are taken from another SharePoint list called Currency List:

The currency column is a Lookup column. Below I can create a new Lookup column:

Back to the Contracts Library, the currency column is a Lookup column. The currency column looks up its values from the SharePoint List Currency List using the CurrencyName column:

Just to point out that the the Contracts Library does not store the actual value of the currency name (eg. "Albania Lek ALL), it stores the selected currency's SharePoint list ID number (eg. For Albania it would be 3). The ID is a unique number that SharePoint generates for each item in the list:

Hope this helps.

Ellis

[Amatrox]

@ekarim2020 

thanks for your input! Also figured this out, that the lookup column is the best solution for this case.

But thank you anyway for your detailed answer!

Cheers,

André