cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Skilled Sharer
Skilled Sharer

Please explain SharePoint Columns

I have a Sharepoint List with 3 columns formatting exactly the same:

  • Single line of text 
    • This is used to store empl id's of each speaker

In my PowerApp, when I reference the columns:

  1. SpeakerId
  2. SpeakerId2
  3. SpeakerId3

The intellisense results display as:

  1. 'SpeakerId (SpeakerId0)'
  2. 'SpeakerId2 (SpeakerId20)'
  3. SpeakerId3

Why the difference.  I thought it might have to do with how I added the column in SharePoint -- Create Column  (from List Settings) vs. Add using the '+' in the quick edit.  But when I tried to reproduce, using both methods, it did not result in the column wrapped in ' '.  Baffled and would like to understand ;).  Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Please explain SharePoint Columns

Hi @KickingApps

 

According to the help, Intellisense shows names in brackets when column names are not unique.

https://powerapps.microsoft.com/en-us/blog/display-names-enters-preview-for-canvas-apps/

 


Since display names are not guaranteed to be unique there is the potential for conflict between two columns. If this happens, the logical name of the conflicting column will be shown in parenthesis after the display name. For example, this entity has two columns with Size as the display name, with cr5ca_sizewidth (shown) and cr5ca_sizeheight (not shown) as logical names:

 Therefore, is there someway that you could have ended up with two SpeakerId and SpeakerId2 columns?

View solution in original post

4 REPLIES 4
Highlighted
Super User
Super User

Re: Please explain SharePoint Columns

Hi @KickingApps

 

According to the help, Intellisense shows names in brackets when column names are not unique.

https://powerapps.microsoft.com/en-us/blog/display-names-enters-preview-for-canvas-apps/

 


Since display names are not guaranteed to be unique there is the potential for conflict between two columns. If this happens, the logical name of the conflicting column will be shown in parenthesis after the display name. For example, this entity has two columns with Size as the display name, with cr5ca_sizewidth (shown) and cr5ca_sizeheight (not shown) as logical names:

 Therefore, is there someway that you could have ended up with two SpeakerId and SpeakerId2 columns?

View solution in original post

Highlighted
Skilled Sharer
Skilled Sharer

Re: Please explain SharePoint Columns

@timl Thank you - it makes sense.  As a note, if you create a column, delete it and create a new column with the same name as that that was deleted, it seems to no longer be unique. Even if you deleted.

Appreciate your response.

Highlighted
Super User
Super User

Re: Please explain SharePoint Columns

@KickingApps Thanks for clarifying how deleting and recreating a new column with the same name produces a different 'logical' name. That's really useful to know.

Highlighted
Super User
Super User

Re: Please explain SharePoint Columns

Hey,

 

Just chipping in here - internal names are constant, permanent and never re-used (think of them as absolute object identifiers - no matter where in sharepoint or o365, if it sees a reference to that specific name, it knows exactly where and what it is).

 

Also SharePoint naming can run you into all sorts of trouble due to it technically have three names when you create an item (Internal, Display, Static).

 

I put a few details here in an old post regarding field sizes, but the short version is that internal names are single-use.

 

There's also this really old blog post on Perficent which covers where Static name might be used from a dev point of view and also covers why sharepoint adds a number to the end of identical columns (spoiler: it's so that internal names are not duplicated and so that they can be referenced specifically without confusion)

 

Cheers,

ManCat


@iAm_ManCat

Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!


Thanks!
You and everyone else in the community make it the awesome and welcoming place it is, keep your questions coming and make sure to 'like' anything that makes you 'Appy
Sancho Harker, MVP


Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (4,966)