Useful Features of PowerApps (12) - AutoSaving of Batch Data

[hpkeong]

Hi

After inspired by Brian Dang and with his ideas, as well as discussion with Taufik & Wife (at Jakarta), I had successfully written an Autosaving of Batch Data (when I flew back from Jakarta back to Malaysia with Malaysia Air Systems (MH), MAS, which really inspired me). They also encouraged sharing even though I think this is too simple for many users here.

The main reason of this idea:

- Patch/Save data at a time is Time-Consuming especially at low band-width countries like Malaysia and Indonesia

- Users had been pampered by the saving speed with local server (intranet) and excel.

- Other reason...maybe.

I wish this maybe a simple yet maybe, useful samples for those having similar internet connection environment like me.

Other users in high speed internet countries, can just IGNORE this idea.

Hope this helps.

Method: Use 2 Collections, 1 Timer, and with some iteration I learnt in during Project Siena.

[mr-dang]

The usefulness of Timer.OnEnd is demonstrated in this solution. Well done.

It took some time, but I implemented this Patch-timer into all of my apps that needed to save. Here's a bonus: you can make the Timer.OnEnd check to see if an entry is already in the table, in which case it will UpdateIf instead of Patching.

If(Oper="+",

If(iter>CountRows(collection),
UpdateContext({iter: iter+1});

If(Last(FirstN(collection,iter))!column in datasource.column,
UpdateIf(datasource,Last(FirstN(collection,iter)),
{column: newdata}),

Patch(datasource,Defaults(datasource),
{column: newdata}))),

UpdateContext({Oper="-"}))

Oper is the on/off switch

iter is the row number in the collection

datasource is the table you are saving to

column is the target data

newdata is the new information you want to save in the column