Update big table

(0) Share

Report

Posted on by Hagru

Hi!

I'm building an app where users fill out forms, send them for review, and then to archives as they're accepted.

In the review, the users want to be able to edit the form that was sent in. I'm aware of the Patch() function, however, I feel like there could be more effective ways of updating the entire set of values that's sent in.

The tables used for each form contain a column for each task, as well as a column for comments on each task. As you can imagine, these checklists can include up to 60 columns for each table. Patching one or two values is no issue, but patching all of them is extremely tedious.

Is there any way to update the entire record and all its columns without having to patch each and every column with the new values?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

RJM07 801 on at

Like (0)

Report

You could use a form and the SubmitForm() Function?

Was this reply helpful? Yes No
Hagru 8 on at

Like (0)

Report

Submitting the form is taken care of. I want to edit the forms that have been submitted.
I don't necessarily want to create a new form.

Was this reply helpful? Yes No
RJM07 801 on at

Like (0)

Report

You can still do that with forms, I believe it requires some form of integrated LookUp() though

Was this reply helpful? Yes No
Hagru 8 on at

Like (0)

Report

I have set it up that way. The submitted forms goes to another page where I have a gallery displaying the submitted forms. From there I can open each form in an edit view. I want to be able to edit each and every column in that form, and save it to the already created form. I can do it with a Patch(), but I don't really want to patch 50 different values individually like this:

Patch(Source, ThisItem, {
Value1 : NewValue1,
Value2 : NewValue2,
Value3 : NewValue3,
Value4 : NewValue4
...
ValueX : NewValueX
});

Was this reply helpful? Yes No
RJM07 801 on at

Like (0)

Report

As far as I'm aware, there is no other way

Was this reply helpful? Yes No
RJM07 801 on at

Like (0)

Report

As far as I'm aware, there is no other way

Was this reply helpful? Yes No