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
[link] [comments]
Want to read more?
Check out the full article on the original site