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

2 REPLIES 2
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/

AHDeveloper
New Member

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (2,957)