Forum Discussion
SharePoint Lists - how to get Display names
When you load data from a SharePoint list, the columns are named using an "Internal" name rather than the "Display" name that exposed when interacting with SharePoint. Is there a recipe that can...
Yes, I know that this needs to be done in PowerQuery and I know that the display names must be available, but they are deeply nested in sub-tables that are not intuitively named - I've spent quite a bit of time looking. Try it, you'll see what I mean.
I'm asking if anyone has a recipe for retrieving them - have you figured out the path through the nested tables to find the display names?
Seward12533
Solution Sage
Solution SageMine are just there so I’d work with the share point owner to ad them to the list. You may need to get the lookup table of ID to Display name.