How to Change a SharePoint List Column's Internal Name
Question details
Users need to change the internal name of a SharePoint list column, which is often automatically generated (e.g., field_1) when importing from Excel templates, to ensure proper integration with Power Automate.

- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Modifying SharePoint list structure and renaming columns for Power Automate and other integrations.
- Observed behavior
- The internal name of a SharePoint list column cannot be modified after it is created, preventing accurate references in external integrations.
Before proceeding, ensure you have Full Control or Design permissions on the SharePoint list and note down all Power Automate flows, formulas, or list views that currently reference the original column.
Create a New Column and Migrate Existing Data
Since SharePoint permanently locks a column's internal name upon creation, the only way to change it is by creating a brand-new column with the correct name and transferring your data.
SharePoint sets a column's internal name exactly as it is typed at the moment of creation. If a column is created from an Excel template, it might default to generic names like 'field_1' or 'field_2'. Because this internal name is used heavily by Power Automate flows and API integrations, it cannot be modified later.
To resolve this, you must create a new column with your desired internal name, copy the data over, update your integrations, and safely delete the old column.
Navigate to your SharePoint list, click 'Add column', and choose the appropriate data type. In the 'Name' field, type the exact internal name you want (without spaces). Click Save.
If you want the display name to contain spaces or differ from the internal name, edit the column settings now and change the name. The internal name will remain locked as what you first typed.
Click 'Edit in grid view' on the SharePoint list. Select the data cells from the original column, copy them, and paste them into the newly created column. Click 'Exit grid view' to save the changes.
Open Power Automate, Power Apps, and any list views or formulas that referenced the old column. Reconfigure them to map to the new column's internal name.
Once all data is safely transferred and your integrations are functioning correctly, go to the old column's settings and click 'Delete' to keep your list organized.

Manage Your Spreadsheet Data Seamlessly with WPS Office
While SharePoint lists have strict rules for internal column names, managing your source data in spreadsheets shouldn't be restrictive. WPS Office provides a lightweight, highly compatible alternative to Microsoft Office, allowing you to easily prepare and format your Excel templates before importing them into SharePoint.
- 1. Download and install WPS Office: Visit the official WPS website to download the free office suite for your desktop or mobile device.
- 2. Prepare your spreadsheet data: Open your existing .xlsx files directly in WPS Spreadsheet. Format your column headers correctly, avoiding special characters or spaces if you plan to import the data into SharePoint.
- 3. Save in standard formats: Save your work in the standard Microsoft Excel format (.xlsx) to ensure a smooth transition when importing to external platforms.

Frequently Asked Questions
How do I find the internal name of an existing SharePoint list column?
Go to 'List Settings' (via the gear icon) and click on the name of the column you want to check. Look at the URL in your web browser; the internal name is the text that appears exactly after 'Field=' at the very end of the URL.
Why did my SharePoint column get named field_1 automatically?
When you create a SharePoint list by importing an Excel spreadsheet, SharePoint often bypasses your custom headers to automatically generate generic internal names (like field_1, field_2) for stability. It then assigns your actual Excel headers as display names.
Can I change a SharePoint column's display name without affecting integrations?
Yes. You can rename a column at any time from the column settings. This only changes the display name visible to users. The underlying internal name remains exactly the same, so your Power Automate flows and integrations will not break.
Will deleting the original column break my Power Automate flows?
Yes, deleting the original column will break any flow, Power App, or calculated formula that references it. You must systematically update all dependencies to point to your new column before you delete the old one.




