Sharepoint is problematic when it comes to giving users control over internal column names. ie. None.
When it comes to mapping display names to internal names, sharepoint;
- Randomly (to me) appends a 0 to some field names
- It deals poorly with spaces (wouldnt replacing prohibited characters with one or more underscores make more sense?)
- Changes internal names when a column is renamed
- Seems to do things differently in the lists table editor cf. sharepoint
- When a list is created using excel import it creates field names of the form field0, field1, etc.
- Doesnt display internal names (surely a tooltip to display it could be implemented)- you only find out when looking at autosuggest in powerapps formulas.
This has been a longstanding issue- Creating all sorts of unreadable and unmanageable code in powerapps.
Since, it appears, sharepoint doesnt have any intention of allowing users control over mapping between internal and display names- is it possible for powerapps to accept either internal or display column names in formulas and map those back to the internal name when it makes calls to the DB?

Report
All responses (
Answers (