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?
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