Why am I getting a field name error on form submit?

[Future_Vision]

Not completely sure what I need to share but here is what I have.

1. I have a screen with 3 forms on (FRM_4, FRM_5 and FRM_6)
2. All forms are using the same data source (Final)
3. Submit button(Submit_BTN) uses a OnSelect formula of Patch('Final', Defaults('Final'),'FRM_4'.Updates,'FRM_5'.Updates,'FRM_6'.Updates)

I am getting a 'cr9c7_name: Field 'cr9c7_name' is required' error. App checker tells me the location is the Submit_BTN. Specifically the formula. I'm not grasping why this is throwing an error. Any ideas?

[WarrenBelz]

Hi @Future_Vision ,

Go to your SharePoint (I assume this is your data source) List and into List Settings and see what fields are required to have input. You may have changed the name (Title is a good candidate), but you need to either write something to this or take away the requirement for it to have data.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Future_Vision]

Hi @WarrenBelz 

I don't believe I am using Sharepoint. I added my datasource this way

[WarrenBelz]

@Future_Vision ,

What are you using to store the data?

If you have simply added an internal table importing an Excel Sheet, you cannot save to this.

[Future_Vision]

I'm building this app in MS Teams. I am assuming this is using some built in datasource. When I create a table it looks like this. 

One thing I did notice is that the most recent table I created does not reference cr9c7_name when I am entering the OnChange formula. 

Set(vendorPartner, VendorPartner_CB_1.Selected.'Vendor Partner')

Other OnChange formulas look more like this

Set(industry,Industry_CB_1.Selected.'Industry (cr9c7_name)')

In this case this is not a valid formula

Set(industry,Industry_CB_1.Selected.'Vendor Partner (cr9c7_name)')

I don't think that is the issue though. if I remove that datacard I still get the error.

[WarrenBelz]

@Future_Vision ,

That was the bit you left out - MS Teams does have an  inbuilt function for this, which I understand is Lists (actually SharePoint) or it may be DataVerse now (I do not use it). It is however telling you that the field crc7_name requires data to be input. Removing the card will make this worse if this is the case. To test this theory, put the card in a Form and give it a Default value.

The other thing I was wondering (I have never tried to create a new record using four different data input sources - particularly ones I cannot control the content) is are you getting one new record or four?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Future_Vision]

How would I find out which field is the cr9c7_name? The all have DataField names that are similar with the exception of the 'name part. For example the Industry combobox has a DataField of 'cr9c7_industry' 

[WarrenBelz · Accepted solution]

@Future_Vision ,

One of the many reasons I do not use the Teams integration - you can launch Canvas Apps from the Teams menu without these debugging (and a host of other) issues. The name suggests it may be the inbuilt Title field, but I am guessing.

Put a new form on the screen and add all the available fields - try to submit the form and the in-built error control should tell you which one is expecting data.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Future_Vision]

Can't really say what the issues was but I did rebuild all of the forms and the CDS tables. Seems to have solved the problem although I have seen some interesting things that I am scratching my head about. For example. Most of my updates for comboboxes look like this

fieldName.'Something (crfeb_something)'

But in some cases the look like this even though the CDS is set up the same.

fieldName.Selected.Something