In this article, you will learn how to find the Internal Field Name for a Column (also referred to as a Field) in a List App. The Internal Field Name is used when creating reports in EPM Live Analytics & SSRS, so it's important for the report writers to know the Internal Field Names for the fields that will be in the reports.
Note: The instructions in this article are applicable to Administrators in the Top Level Site as well as to Power Users who have Owner permissions on a workspace.
1. Note about Column/Field Names
When creating columns/fields in a List Apps, it is important to be consistent with the internal field names, also referred to the back-end field names. The internal field name is the initial name of the field when it is first created and saved. Once a column is created, it may be renamed to something more user friendly, with a space between words, etc. This new name is the Display Name of the Field. However, the original internal field name never changes.
For example, if you are trying to create the % Complete field, you will need to create a column called PercentComplete in the List App. It is a recommended best practice to name List Columns as one word without numbers or special characters. If a column is created with a space, the internal field name will later show a combination of characters where the space was.
To find the internal field name of an existing Column/Field, go to the List Settings page. Select the Column name link to view the Column settings. Click the URL address bar. The far right of the URL shows Field=FieldName.
2. Navigate to the List Settings
Navigate to the List App.
- On the View Toolbar, select the Settings Gear.
3. Select Column to Open Column Settings Page
Open the Column again to verify the Internal Field Name.
3.1. Verify Column Internal Field Name
- The Internal Field Name doesn't change. The Internal Field Name is found in the URL of the Column Settings page.
- The Column's Display Name in the Column Name section can be modified, but that will not change the Internal Field Name.
3.2. Close Column Settings
When finished, click Cancel.