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