cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Matthew_Cooley
Frequent Visitor

Column names not updating in collection with sharepoint

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

1 ACCEPTED SOLUTION

Accepted Solutions
Meneghino
Community Champion
Community Champion

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/

View solution in original post

1 REPLY 1
Meneghino
Community Champion
Community Champion

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/

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,623)