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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / PATCH a Batch of Recor...
Power Apps
Unanswered

PATCH a Batch of Records at One Time

(0) ShareShare
ReportReport
Posted on by 2,944

Hi PG:

 

Enter data and Save (Patch or SubmitForm) takes about 10-15 seconds sometimes due to Slow Internet in our region.

Is there any way to:
- Collect data, say for 20 (into Collection)

- Patch or SubmitForm, on one click.

This will improve our slow connection problem.

 

Please help us in our situation. We are not from USA and other advanced country.

TQ

Categories:
I have the same question (0)
  • LisaChen1226 Profile Picture
    Microsoft Employee on at

    Hi PG,

     

    From your description, my understanding is that you want to create multi records at one time.

    You can create multi records at one time using the following:

     

    Collect(Destinations, { {Cities: “Beijing”, States: “China”}, { Cities: “NY”, States: “America”}....)

     

    Or you can:

    Insert two input text control, and rename them as  'City' or 'State', 

    Insert two input text control, and rename them as  'City1' or 'State1', 

    ......

    Insert a Button. Set its OnSelect property to the following function:

    Collect(Destinations, {Cities:City!Text, States:States!Text}, {Cities:City1!Text, States:States1!Text} ...)

     

    Reference:

    https://powerapps.microsoft.com/en-us/tutorials/create-update-collection/

     

    Best Regards,

    Lisa Chen

  • hpkeong Profile Picture
    2,944 on at

    Hi Lisa:

     

    Well, Brian has shared before and we are discussing over PATCH.

    Collection is not an issues (anyway thanks). Collection is alwasy temporary into temp file at no delay.

    We can even SaveData and Export as XML and Import Again (this is useful for Backup) which used during Siena era.

     

    The main issues are: Patch for each record takes long time (> 5 seconds or more for slow connecting speed country, like mine). So, Brian has 2-records patching examples.

    My case, is it is the USER decides when to Patch a batch of record to expedite the whole saving proces to cloud.

     

    I wish PowerApps Staff has some more idea or it is impossible?\

     

    TQ Lisa

  • Brian Dang Profile Picture
    3,976 on at

    Thank you for the example on how to collect multiple rows--I learned something new!

     

    Maybe the same pattern can be applied to Patch for multiple rows. Or is it already implemented--I'll try now.

  • Brian Dang Profile Picture
    3,976 on at

    I tried:

    Patch(source,Defaults(source),{column: data1},{column: data2})

    Collect(source,{column: data1},{column: data2})

     

    Collect will save both of those rows. Patch will overwrite data1 with data2 because they're both tied to the new row "Defaults(source)".

     

    If Patch could somehow make a relationship between an existing collection and a datasource, I think it would work more effiiciently than specifying the column again and again as in the Collect example above.

  • Community Power Platform Member Profile Picture
    on at
    Hi Mr dang


    I have a similar issue when 2 or more users want upload their data at the same time to cloud, second user always overwrite first users data.
    Did you find solution for your problem?

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard