Submit Button Error - Form needs to be Editable

[emmaettinger12]

Hi, bit of a beginner here.

I am setting up a new form connected to a SharePoint list.  I want to add a submit button but keep getting the error: "The Function expects an editable form as its input" 

I have read through the blogs and I have changed everywhere I can see so the DefaultMode is Edit.

Please help me with what I am doing wrong.  Its supposed to be so simple but I can't get it to work. TIA

[poweractivate]

'Data Test Form' is the Data Source not the Form!

It should be 

SubmitForm(Form1)

See if it helps @emmaettinger12 

[emmaettinger12]

Hiya,

YYYEEESSS... thank you.  I finally worked that out as I submitted my query here.

How do I then submit if I have a multipage form.... i.e. three forms on the using the same data source?

Thank you

[poweractivate · Accepted solution]

Having three forms on the same screen, each collecting different information from the same data source, can be managed using context variables to store intermediate data. Here's how you can approach this, with a simple example as well to help illustrate it:

1. Create Three Forms on the Same Screen

Design three forms: Form1, Form2, and Form3 on the same screen. Connect them to the same data source:

• Form1: Fields for First Name and Last Name.
• Form2: Fields for Age and Birthday.
• Form3: Fields for Description, Likes, Dislikes, etc.

2. Use Context Variables to Store Intermediate Data

You can use the UpdateContext function to store data from each form in context variables after a user completes each section. For example, after completing Form1, you might have a "Next" button with the following formula:

UpdateContext({varForm1Data: Form1.Updates}); // Stores the data from Form1

Repeat this for Form2 and Form3 as needed.

3. Create Final Submit Button

When the user has completed all three forms, you can have a final "Submit" button to combine the data from all three context variables and use the Patch function to update your data source.

Here's an example of that to use for the OnSelect of this final Button:

Patch(
  'Data Test Form', // Your data source name
  Defaults('Data Test Form'), // Creates a new record
  {
    FirstName: varForm1Data.FirstName,
    LastName: varForm1Data.LastName,
    Age: varForm2Data.Age,
    Birthday: varForm2Data.Birthday,
    Description: varForm3Data.Description,
    Likes: varForm3Data.Likes,
    Dislikes: varForm3Data.Dislikes
    // Add other fields as needed
  }
)

4. Reset Forms (Optional)

After submitting the data, you may want to reset the forms.

If so, you may want to add the following formulas right after the above Patch:

ResetForm(Form1); ResetForm(Form2); ResetForm(Form3)

Make sure that the forms are configured correctly to update the context variables with the correct field values. The Updates property of the form should contain the data that the user has entered.

See if this helps @emmaettinger12 

[emmaettinger12]

Thank you so much.

This is just what I needed.

Appreciate your help.