Submitting a form for a new record, Item value

[Connor_Taylor]

Hi all,

What should the value for 'Item" be for the form I'm submitting if I want to create a new record? (not edit a current record)

It's currently blank, so I get the error 'a value must be provided for item' and I imagine this is meaning the actual 'item' value.

Thank you 

[Drrickryp · Accepted solution]

@Connor_Taylor,

The form mode is usually set by an EditForm(Form1) or NewForm(Form1) function in a button or icon’s OnSelecr property. The Item property for an Edit form is usually Gallery1.Selected. it is ignored when the form mode is New. If you are only using your form for submitting new data, set it’s default mode to New in the right hand column with the  form selected (use the breadcrumbs on the bottom of the screen) rather than Edit. 

[Connor_Taylor]

Thank you, your explanation was very helpful.
But it seems I had already done all this and still get the error 'The request operation is invalid. Server Response: a value must be provided for item'.

Any thoughts on what this could be then?

The form is set to 'New' and is called by a NewForm(form1) and every value in the form has a text input assigned to it.

[Drrickryp]

What platform are you using, excel, sharepoint, etc. If it's sharepoint, are any columns Choice or lookup types?

[Connor_Taylor]

Data is connecting to a SQL server