Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

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

(0) ShareShare
ReportReport
Posted on by 634

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?

Categories:
  • Future_Vision Profile Picture
    634 on at
    Re: Why am I getting a field name error on form submit?

    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

  • Verified answer
    WarrenBelz Profile Picture
    146,645 Most Valuable Professional on at
    Re: Why am I getting a field name error on form submit?

    @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 Profile Picture
    634 on at
    Re: Why am I getting a field name error on form submit?

    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 Profile Picture
    146,645 Most Valuable Professional on at
    Re: Why am I getting a field name error on form submit?

    @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 Profile Picture
    634 on at
    Re: Why am I getting a field name error on form submit?

    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. 

    Future_Vision_0-1617404001905.png

     

    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 Profile Picture
    146,645 Most Valuable Professional on at
    Re: Why am I getting a field name error on form submit?

    @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 Profile Picture
    634 on at
    Re: Why am I getting a field name error on form submit?

    Hi @WarrenBelz 

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

     

    Future_Vision_0-1617403141015.png

     

  • WarrenBelz Profile Picture
    146,645 Most Valuable Professional on at
    Re: Why am I getting a field name error on form submit?

    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.

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,645 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,997 Most Valuable Professional

Leaderboard