Forum Discussion
SharePoint Lists - how to get Display names
Anonymous,
I understand, however it would help if you could tell us what your SharePoint list looks like and what column types are in it?
I dont' really know if you can directly retrieve a person's display name fromn a sub-table unless the SharePoint list column itself is a person/group column to begin with - in this case it is quite staright-forward as the sub-table is named similarly as the SharePoint list column.
Br,
T
I'm not talking about a person's display name. I'm taking about the display name of a column in a list.
When I retrieve the columns from a list, the names of the columns often do not match the column names displayed in SharePoint. For example:
"Primary Geography Country" is brought in as "Primary Geography Co"
"Launch: Overall Readiness" is brought in as "Launch: Overall_x002"
"Complete" gets brought is as "AllDone" (because I had originally called the column AllDone and then changed it)
"Introduction" gets brought in as "Title" (because I changed Title to Introduction)
I'm looking for a recipe to drill into the nested tables in what is returned for the list to get the display names. My hope is that these are stored consistently in the data structures, regardless of the type of data each column holds.
Dale
Because this thread went into the weeds, I reposted here: https://community.powerbi.com/t5/Desktop/How-to-retrieve-quot-correct-quot-column-names-from-SharePoint/m-p/484431#M225556
Anonymous
I see, sorry for misunderstanding...