Sharepoint internal column names prefixed with “field_”

%3CLINGO-SUB%20id%3D%22lingo-sub-2828890%22%20slang%3D%22en-US%22%3ESharepoint%20internal%20column%20names%20prefixed%20with%20%E2%80%9Cfield_%E2%80%9D%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2828890%22%20slang%3D%22en-US%22%3EI%20build%20quite%20a%20few%20large%20lists%20from%20excel%20files%20in%20Sharepoint%20Online.%20Recently%20I%20noticed%20that%20when%20doing%20this%20it%20prefixes%20all%20of%20the%20internal%20column%20names%20with%20%E2%80%9Cfield_%E2%80%9D.%20So%20if%20I%20have%20a%20column%20in%20the%20excel%20table%20called%20%E2%80%9Cemail%E2%80%9D%20the%20display%20name%20of%20the%20column%20will%20be%20%E2%80%9Cemail%E2%80%9D%20but%20the%20internal%20column%20name%20will%20be%20%E2%80%9Cfield_email%E2%80%9D.%20It%20didn%E2%80%99t%20used%20to%20do%20this%20and%20has%20put%20me%20in%20a%20bind%20with%20a%20power%20app%20I%20have%20developed%20that%20is%20looking%20for%20the%20unprefixed%20column%20names.%20Any%20idea%20what%20causes%20this%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2828890%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2829488%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20internal%20column%20names%20prefixed%20with%20%E2%80%9Cfield_%E2%80%9D%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2829488%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20Not%20Sure%20With%20My%20Answer%20To%20Tell%20To%20U%20Bro%20But%20I%20Suggest%20U%20To%20Ask%20Help%20in%20Official%20Microsoft%20Sharepoint%20Help%20%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fsharepoint%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fsharepoint%20.%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20Hope%20This%20Will%20Be%20Some%20What%20Helps%20and%20Wants%20To%20Get%20Ur%20problem%20Solved%20For%20Ur%20Question%20Called%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.kbstraining.com%2Fsharepoint-training.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ESharepoint%3C%2FA%3E%20internal%20column%20names%20prefixed%20with%20%E2%80%9Cfield_%E2%80%9D.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
I build quite a few large lists from excel files in Sharepoint Online. Recently I noticed that when doing this it prefixes all of the internal column names with “field_”. So if I have a column in the excel table called “email” the display name of the column will be “email” but the internal column name will be “field_email”. It didn’t used to do this and has put me in a bind with a power app I have developed that is looking for the unprefixed column names. Any idea what causes this?
1 Reply
Not particularly aware of this issue, but I guess the process of creating a list from Excel it's responsible of adding this field prefix and also to remove any character that can make dirty the internal name of a list column