1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Excel Power Query & Sharepoint Choices

Hi guys,

I have a Sharepoint list with a choices column into it.

I have also an Excel file from which I have power queries to get data from sharepoint lists, no worries about that, it's working.

I would like to retrieve only the choices values from my sharepoint choice column into excel through Powerquery to have a "referential" sheet.

For example :

In SP :
List T_PROJECT

> Column PROJECT_ID -> Number

> Column PROJECT_STATUS -> Choices (New, In progress, Completed)

In Excel, I would like to retrieve the "New", "In progress" and "Completed" values into a power query.
I cannot do it through the list itself, because I could have only 1 project with status "New", and I could like to get all choice values.

Is it possible ? And how ?

Thanks

submitted by /u/Agreeable_Economy223
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#generative AI for data analysis
#financial modeling with spreadsheets
#rows.com
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#SharePoint
#Excel
#Power Query
#choices column