Getting SharePoint List Values for Choice Column

[cobyers]

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.

[v-xida-msft · Accepted solution]

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.

I have made a test on my side and my flow’s configuration as below:The flow works successfully as below:

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

[cobyers]

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 · Accepted solution]

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" 

Hope This Helps.

Regards,

Chandrashekhar Kumawat

Emerson, Pune, India.

kumawatshekhar71@gmail.com

[GabrielStJohn]

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