Submit a field outside my edit form

[codeworks]

HI Everyone,

I am working on an application where I have my edit form on one screen(My first Screen) and another data on another screen. I want  to submit both my edit form and the data on the second screen to a SharePoint list. Patch Function comes to my mind, but i have quite a lot of form fields on the first form. Is there any other way i can submit both data to my SharePoint lists

[Pstork1]

If none of the fields on the second screen are required fields in the list you can submit the form from the first screen and then do a patch to update that item with the values from the second screen. The key is to use some value from the first form to lookup the record after the submit to do the patch.

[LaurensM]

Hi @codeworks,

If both the form and additional controls refer to the same table/list, you could patch the Form updates and the additional values:

Patch(
    TableName,
    Defaults(TableName), //if you want to update replace this with a reference to the record (e.g. LookUp, Gallery.Selected...)
    FormName.Updates,
    {
        AdditionalColumn1: "Field 1 outside of your form",
        AdditionalColumn2: "Field 2 outside of your form"
    }
)

If they refer to separate tables, you would use a separate SubmitForm (for the form) and Patch action (for the additional controls) to send the data to the respective tables.

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!

[Ethan_R]

Hi @codeworks ,

Try to use collection to store data of a record from both screen, then use patch to save entire collection of record(s) at once. 

This will help you to manage any sequence and also modify certain data or add/drop columns as needed. 

Patching using collection is faster when you are doing bulk updates. 

Note: Unique ID should be included in the collection to update existing records.

Hope this helps 

[codeworks]

Patch(
    'checklist',
    Defaults('checklist'),
    ReqForm.Updates,
    {
     Total: txtTotal
    }
)

This is throwing Network Error when using patch Function

[LaurensM · Accepted solution]

Hi @codeworks,

Is txtTotal a Text Input control? Here you should append .Text to get the actual value from the control.

Should Total be a number column and not text, use Value(txtTotal.Text)