web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Apps
Unanswered

Update big table

(0) ShareShare
ReportReport
Posted on by 8

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:
I have the same question (0)
  • RJM07 Profile Picture
    801 on at

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

  • Hagru Profile Picture
    8 on at

    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.

  • RJM07 Profile Picture
    801 on at

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

  • Hagru Profile Picture
    8 on at

    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

    });

  • RJM07 Profile Picture
    801 on at

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

  • RJM07 Profile Picture
    801 on at

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 491

#2
WarrenBelz Profile Picture

WarrenBelz 407 Most Valuable Professional

#3
11manish Profile Picture

11manish 331

Last 30 days Overall leaderboard