Forum Discussion
GovindPrajapat
Aug 16, 2023Copper Contributor
Sharepoint Column Name Issue
Hi, I have created a list on SharePoint. After that I renamed the list and renamed a few columns as well. Also I have renamed the Site. Now when I am trying to access this list in my PowerApps an...
Lalit Mohan
Aug 16, 2023Iron Contributor
Hi, GovindPrajapat
The reason why you are seeing "field1", "field2", etc. for a few columns in your PowerApps and Power Automate Flows is because SharePoint stores the actual column names in a hidden property called the Internal Name. When you rename a column, SharePoint only changes the Display Name of the column. The Internal Name remains the same.
To get the actual column name, you can use the following steps:
- Go to the list settings page for the list that contains the renamed columns.
- Click on the Columns tab.
- Click on the name of the column that you want to get the internal name for.
- The internal name of the column will be displayed in the URL of the page, after the Field= parameter. For example, if the column name is "Name", the internal name will be Field=Name.
Once you have the internal names of the columns, you can use them in your PowerApps and Power Automate Flows.
To get rid of the issue, you can either:
- Recreate the list and rename the columns again. This will reset the Internal Names of the columns to the new names.
- Use the internal names of the columns in your PowerApps and Power Automate Flows.
Here are some additional resources that you may find helpful:
- How to find the internal name of list or library columns: https://sharepointstuff.com/2022/02/09/find-internal-column-name/
- Get Internal Name of a Column in SharePoint Online using PowerShell: https://www.sharepointdiary.com/2021/01/get-field-internal-name-in-sharepoint-online-using-powershell.html
I hope this helps! Let me know if you have any other questions.