cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cobyers
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
v-xida-msft
Community Support
Community Support

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

Anonymous
Not applicable

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
v-xida-msft
Community Support
Community Support

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.

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

Anonymous
Not applicable

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

Hello, @cobyers!

Have you had an opportunity to apply @Anonymous‘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
Power Automate | Power Virtual Agents
Super User Program Manager



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.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (2,789)