How to sync updated record with local collection real time

(0) Share

Report

Posted on by Owizardo

Hello,

Im struggling to keep in sync my local collection and my Datasource after updating a record.

Here's my dilema, I have a simple gallery where on click of a button, it will collect from my data source and then display the data in a gallery.

ClearCollect(Local_Collection, 
 Filter(DataSource, 
 Parent_ID = ThisItem.ID)
 )
)

User would then modify record or records, and on save it will send a patch to the Datasource. It would then send them back to the main menu. So far all this is working up to this point, no problem.

The issue I came across is that users might need to update the same batch of records again a few seconds later. So if they try to access the record again, the old data shows up but if you go back again 30 seconds later, It finally grabs the updated record.

There seems to be a delay between saving the data and being able to grab the updated record from a Sharepoint list. Has anyone come across this and know how to get around this?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Dawidvh 1,346 on at

Like (0)

Report
Hi @Owizardo,

I know it shouldn't matter, but what datasource are you using,? We have found some caveats with collecting SharePoint lists, and then patching them back to SharePoint.

Does the collection have the same key column as the datasource and are all column names exactly the same? You could try and patch the collection when the user updated the record, then issue a Patch command (or UpdateIf in the case of SharePoint list to avoid author access problems.) to patch the datasource with the entire collection.
Patch(dataSource,localCollection)
You could also consider using timers to kick off the second sync after the user input action has completed.

Let me know if you don't come right.

twitter: @dawidvh
youTube: https://www.youtube.com/channel/UCIMe_ErQZP5chbI9UyW0xLw

Was this reply helpful? Yes No
Owizardo 98 on at

Like (0)

Report

Thanks for the quick response, I ended doing that but I also had found that I had activated a cache mode which was not helping me in this scenario. Once I turned it off, everything now seems to be running alot smoother. Thx again.

Was this reply helpful? Yes No