Column names not updating in collection with sharepoint

[Matthew_Cooley]

I am currently working with a sharepoint list that I am frequently changing. I will often change column names, change the order of the columns, and add/delete columns from sharepoint. My powerapps application has a formula to Clearcollect from my sharepoint list, after the sharepoint list has been refreshed. However, the changed column names are not showing up in the collection. 

In more detail, I had noticed I had a space in one of my column names, since it was showing the x_002 thing, so I went to my sharepoint list and removed the space. I am displaying the collection in powerapps as a table, and I cannot seem to get the column name to update so it doesn't have the x_002 in it. I have removed the collection completely, closed the app, restarted, removed all data connections then re-added, created a new collection. Nothing has seemed to get this to update with the correct column name. 

Do collections not function in the way I'd like to use them?

Thanks,

Matt

[Meneghino · Accepted solution]

Hi @Matthew_Cooley

The problem is with SharePoint and not with PowerApps.

When you create an object such as a list, document library or column in SharePoint, it will be created with an internal SharePoint name.  This name will never change even if you change the name in SharePoint after creation.  You can see this by looking at the link in the browser when you browse to the object in SharePoint.  PowerApps rightly uses the column internal name as opposed to the display name.

The way to get around this is to create a new column with the correct name and then copy-paste the data into it.

In any case it is never a good idea to have list or column names with spaces in them.

Hope this helps.

PS There is much on the web on this, for example:

http://sympmarc.com/2015/01/27/get-the-internalname-for-a-sharepoint-list-column/

[AHDeveloper]

Open the Transform Data Window > Advanced Editor > Change the api version to 14 the previous version [ApiVersion = 14].   

[Dasunk]

Yes. You are correct. thank you 🙂

[PhilMan]

Where can I find the "Transorm Data Window"?

[AHDeveloper]

transform data button on the power bi desktop > it opens a new window and find the 'Advanced Editor' change the api number to the previous version. It will load and give you a source error and choose the table to you connecting

[PhilMan]

ok, this is the reason I can't find it in PowerApps-Studio 🙄

I have the same problem here in MSPA. I changed properties and column names in sharepoint list. The changes don't take effect in PowerApps. Refreshing doesn't help. Really strange