Best Way to Save Data Entered from Controls in Gallery to SharePoint List

(1) Share

Report

Posted on by I0-23070210-0

Hi, I'm having trouble to decide which function is the best to save all the data entered to SharePoint list. Should I use Patch function or Collect function? and could you guys perhaps help me write the general formula for it? Below is the UI for my apps:

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,974 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi,

You are confusing something.

Patch is an Expression to create or update data, where as, Collect is an expression to add something to a collection.

Since you are talking about Saving Data you have a couple of options

Option 1

1. You can add an Edit/New Form on the screen.

2. Put it in New Form

3. Add a Button and call it Save/Submit whatever you want

4. Once the form is populated, you would do a FormName.Submit() to save the record.

Option 2

1. Use a Patch Statement for a New Record or Update

// to create a new one Patch(MyTableName, Defaults(MyTableName), { EmployeeNumber: EmployeeNumberCombo.Selected, // I ASSUME HERE the back end is an Option set 'Work Order': WorkOrderTextInput.Text } ); // UPDATING a record - requires passing a reference to the record to update Patch(MyTableName, LookUp(MyTableName, SomeColumn=SomeValue), { EmployeeNumber: EmployeeNumberCombo.Selected, // I ASSUME HERE the back end is an Option set 'Work Order': WorkOrderTextInput.Text } );

Was this reply helpful? Yes No
I0-23070210-0 20 on at

Like (1)

Report
Copy link

Link copied!

@FLMike

Hi!

Oh! I think you just cleared up my confusion. But, is there no way to just use a Gallery to save the record?

Was this reply helpful? Yes No
Seth18 146 on at

Like (1)

Report
Copy link

Link copied!

Hi!

I am not an expert or anything, but you can try doing this Save as Draft in Power Apps Form (youtube.com) as it is actually helpful!

Was this reply helpful? Yes No