I am using Power Apps to create a simple entry log that is connected to an Excel Spreadsheet hosted on a Sharepoint site. When making the connection I selected the option for Power Apps to automatically generate a unique record ID (__PowerAppsId__). This is by default a required field. When I create a new entry the __PowerAppsId__ field is blank. Once I finish entering data into the other fields and click the Submit button, the __PowerAppsId__ field border turns red and it doesn't allow me to submit the entry. Then I enter a random value into the field and hit Submit and it works. The value that I enter changes into a value Power Apps auto-generated. (For example, I enter '1', hit submit and it changes to 'f001d48c-73b2-4995-ac27-8139c23b9b23').
This isn't so much a problem but is confusing to users. As a workaround I tried defining the Default property, but that only had intermittently success. Sometimes the record would submit properly and sometimes it would give me an error that I "could not save." Also, if a Default value is defined, the field always displays that value ('1), regardless of the actual underlying value 'f001d48c-73b2-4995-ac27-8139c23b9b23' in the spreadsheet.
Why do I have to enter any value at all if it overwrites with an auto-generated number?
