I am just starting out using powerapps and wanted to build an app using the CDS. In doing so I wanted my primary field to unique and I discovered the handy Autonumber feature of CDS. This was great, but once I went to power apps and submitted the form with my new record it gave me errors. It appears that posting the record through powerapps is not generating the next sequence of autonumber. Is there a work around for this. Attached is a simple table and form showing my problem.
PS. Also does anyone know why CDS creates (base) fields for currency?
CDS Entity Definiton and Autonumber field (Primary)Powerapps Edit FormError on Submit form if you do not manually enter PID value