cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cobyers
Level: Powered On

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
Community Support Team
Community Support Team

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

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
Community Support Team
Community Support Team

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

cobyers
Level: Powered On

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

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

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
Microsoft Flow Community Manager

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 276 members 4,190 guests
Please welcome our newest community members: