cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Getting SharePoint List Values for Choice Column

I'm using Flows to grab data from the SharePoint lists and populate a SQL Table. However, I can't grab values from the SharePoint lists that were choices of preset values.

 

I understand that for Choice Values SharePoint creates a separate list of the acceptable answers with an ID, I just can't even get the ID.

 

Example for clarity: In hypothetical table "Favorites" I could have a column labeled "Color". When a user is trying to input their favorite color, they choose from a list: "Red", "Green", "Blue", etc., and those values are stored in a list on SharePoint called "Colors".

When I'm trying to grab rows from Favorites and insert them into a SQL Table, the "Color" value is not accessible or in the dynamic content.

 

Please Help.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Getting SharePoint List Values for Choice Column

Hi @cobyers,

 

Could you please share a screenshot of your Choice column’s configuration?

Do you enable Choice column allow multiple selections?

Do you want the Choice column to refer to values that stored in another SharePoint list?
If we want to define the list of choices, we need to type each value on a separate line in Type each choice on a separate line box.16.JPG

I have made a test on my side and my flow’s configuration as below:17.JPGThe flow works successfully as below:18.JPG

  

 

If you want to Color column refer to values that stored in other SharePoint list, please consider change the data type of Color column to Lookup.

 

 

More details about the List column types and options, please check the following document:

List and library column types and options

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Advocate V
Advocate V

Re: Getting SharePoint List Values for Choice Column

Hi,

 

Tried and tested solution:

 

1. Create a calculated column using your "Color" column.

2. Keep datatype of this calculated as "single Line of Text"

3. Now, this calculated column will be available in flow in "Dynamic Content" 

 

Chcoicefield.png

 

Hope This Helps.

Regards,

Chandrashekhar Kumawat

Emerson, Pune, India.

kumawatshekhar71@gmail.com

View solution in original post

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Getting SharePoint List Values for Choice Column

Hi @cobyers,

 

Could you please share a screenshot of your Choice column’s configuration?

Do you enable Choice column allow multiple selections?

Do you want the Choice column to refer to values that stored in another SharePoint list?
If we want to define the list of choices, we need to type each value on a separate line in Type each choice on a separate line box.16.JPG

I have made a test on my side and my flow’s configuration as below:17.JPGThe flow works successfully as below:18.JPG

  

 

If you want to Color column refer to values that stored in other SharePoint list, please consider change the data type of Color column to Lookup.

 

 

More details about the List column types and options, please check the following document:

List and library column types and options

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Regular Visitor

Re: Getting SharePoint List Values for Choice Column and Lookup Column

Kris,

Thank you for the in-depth reply! I just needed to tweak something I saw in your screenshots and now the choice columns are working for me.

 

I still do have some issues with the Lookup Columns, I can't get the ID or value of the choices. Do you have any suggestions?

 

Thanks again!

Corbin

Highlighted
Advocate V
Advocate V

Re: Getting SharePoint List Values for Choice Column

Hi,

 

Tried and tested solution:

 

1. Create a calculated column using your "Color" column.

2. Keep datatype of this calculated as "single Line of Text"

3. Now, this calculated column will be available in flow in "Dynamic Content" 

 

Chcoicefield.png

 

Hope This Helps.

Regards,

Chandrashekhar Kumawat

Emerson, Pune, India.

kumawatshekhar71@gmail.com

View solution in original post

Highlighted
Administrator
Administrator

Re: Getting SharePoint List Values for Choice Column

Hello, @cobyers!

Have you had an opportunity to apply @chandrashekhar‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!


Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

-Gabriel
Community Manager
Microsoft Power Automate | Power Virtual Agents
Are YOU a member of a Power Platform User Group?
Fill out This Form to claim your Community User Group Member Badge!

Helpful resources

Announcements
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (4,323)