Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

App cannot create record and throwing up customerid error

Hi All,


Just dipping my toes in the water with canvas apps and I'm trying to create an app for managing opportunities on dynamics. It's deleting the records without any problems but the issue is with the edit and create records function. It seems that every time I set off the create a record action it throws up the below error:


The problem is that when I add in the customerid field, its just a blank box (it's a GUID field):


If I then hit submit it then throws up this error:



I'm not really sure where to go from here, so any help would be really appreciated! 


Super User
Super User


Go back into the table and turn off the required property for the customerid. It is assigned automatically.

Thank you for the quick response. What if that wasn't an option? It's sitting under a managed solution which isn't something that we ourselves put together and therefore I can't change that field to a different status.


Also would that then not link the opportunity to the contact record?

Super User
Super User


The Default value of a foreign key should point to the primary key of the parent table.  You should not be able to create a record on the many side of a one to many relationship unless you have a record in the one side. 

Helpful resources

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,206)