Customizing Sharepoint form in power app - submit form

Question

I am customizing SharePoint library form in Power app.

OnSave

event there is:

SubmitForm(SharePointForm1)

However I want to save some custom values by applying formulas based on user selection and save to SharePoint fields without user knowing via form. How can i achieve it ?

I have tried

    SubmitForm(SharePointForm1);
  Patch(
       Test_DocumentLibrary,
      Defaults(Test_DocumentLibrary),
       {
                   
                    TestCol :"Ac"
             
        }
        );

but the above returns the error

network error when using patch function: the requested operation is invalid.

I have also tried by removing the line

SubmitForm(SharePointForm1);

Answer 1

If you are trying to add values to custom columns in same library, follow below steps for all custom columns:

1. Add the fields to your form by selecting form control and then fields from property pane at right hand side

2. Set Visible property of data card to false to hide those fields from users.

3. Set their Default and Update property to your calculated formula as per your requirements

4. Those fields will be saved/updated automatically when user saves the form using SubmitForm(SharePointForm1).