cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Normal Column Names for Sharepoint Lists Used in power Apps

Hello,

 

I've only noticed that this occurs when using a Sharepoint list, and not when I use an Excel Spreadsheet. I created a custom list in Sharepoint with the colums labeled like this.

 

Capture.PNG

 

However, when I try to use this list in PowerApps, the column headers look like this...

 

Capture2.PNG

 

 

Is there a way to control how the column name gets bought over into Powerapps? It becomes extremely confusing and tedious (and actually nigh impossible to work with) when putting in formulas. 

 

Advice is appreciated.

 

Thanks,

KL

14 REPLIES 14
Highlighted
Community Support
Community Support

Re: Normal Column Names for Sharepoint Lists Used in power Apps

Hi Kleach,

 

I test this issue with both Excel table and SharePoint custom list and I get the same issue with you. When the App is created from data with SharePoint custom list, the column headers are not the column name in the list.

 

About this issue, I would suggest you submit an idea at PowerApps Ideas Forum, so it might considered as future releases:
https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper II
Helper II

Re: Normal Column Names for Sharepoint Lists Used in power Apps

Any way to get around this issue? With one sharepoint list, the names came in "mostly" correct to the point where I could assume what the column was. 

 

When I added another sharepoint list, the column names came in as "i20b", "OData_x006d_p97", "bnln", etc. This makes working with this list as a datasource impossible.

 

What can I do to get these column names mapped correctly?

Highlighted
Helper II
Helper II

Re: Normal Column Names for Sharepoint Lists Used in power Apps

@v-yamao-msft - is the column naming influenced by the security settings of the list by any chance? I don't understand why I don't get "real" names. I can't work with "i20b", "OData_x006d_p97", "bnln"

Highlighted
Power Apps
Power Apps

Re: Normal Column Names for Sharepoint Lists Used in power Apps

SPO makes up these "crazy" column names, and I cannot explain why or how. PA will only make them "crazier" if their syntax clashes with something in PA and we need to escape them somehow (eg they contain a space). I'd dig around in the SPO docs if I were you, I assume there is a way of controlling the "real" column names.

Highlighted
Helper II
Helper II

Re: Normal Column Names for Sharepoint Lists Used in power Apps


@AndyPennell wrote:

SPO makes up these "crazy" column names, and I cannot explain why or how. PA will only make them "crazier" if their syntax clashes with something in PA and we need to escape them somehow (eg they contain a space). I'd dig around in the SPO docs if I were you, I assume there is a way of controlling the "real" column names.


Can you verify this statement? 

 

I have two identical sharepoint lists in 2 separate Sharepoint sites. When I bring in the data connection for the first one, all of the column names are perfect. The second one produces unintelligble names and makes it useless. 

 

Can we have someone from MS or the team respond please? Very frustrating...

Highlighted
Helper II
Helper II

Re: Normal Column Names for Sharepoint Lists Used in power Apps

Can anyone help here?

Highlighted
Advocate III
Advocate III

Re: Normal Column Names for Sharepoint Lists Used in power Apps

I have the same issue, so bumping this. Doesn't make sense t all why the names would com across crazy like that. 

Highlighted
Helper II
Helper II

Re: Normal Column Names for Sharepoint Lists Used in power Apps

Yeah.. quite disturbing on the lack of official communication on this issue from MS and the PowerApps team. 

 

However, our SharePoint admin did change the "type" of site that the offending SharePoint list was within. I think he changed it to a "team site" and then when I accessed the list within that site, the names did appear normal.

 

 

Highlighted
Power Apps
Power Apps

Re: Normal Column Names for Sharepoint Lists Used in power Apps

I dont know much about SPO, other than this column naming is painful. The Internet seems to know quite a lot, here is a useful article I found: http://www.sharepointdiary.com/2011/06/sharepoint-field-display-name-vs-internal-name.html

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,266)