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)

Suggested answer

Michael E. Gernaey 53,488 Super User 2025 Season 2 on at

Like (1)

Report
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

@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

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