cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Amatrox
Resolver I
Resolver I

Add value to selection column in a SharePoint

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: 

Amatrox_0-1626850327001.png

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

Amatrox_1-1626850493653.png

The country column looks like this:

Amatrox_2-1626851189772.png

 

 

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é

1 ACCEPTED SOLUTION

Accepted Solutions
ekarim2020
Super User
Super User

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:

ekarim2020_0-1626856427255.png

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

ekarim2020_2-1626856679158.png

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:

ekarim2020_1-1626856545817.png

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:

ekarim2020_3-1626857014184.png

Hope this helps.

Ellis

View solution in original post

2 REPLIES 2
ekarim2020
Super User
Super User

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:

ekarim2020_0-1626856427255.png

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

ekarim2020_2-1626856679158.png

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:

ekarim2020_1-1626856545817.png

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:

ekarim2020_3-1626857014184.png

Hope this helps.

Ellis

Amatrox
Resolver I
Resolver I

@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é

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,953)