Avoiding concurrency issues

(0) Share

Report

Posted on by msabau

270

Hello, I've looked on the internet and found a few solutions, but none of them really fit my app.

The easiest way I found to solve concurrency issues is to update the record that I'm currently editing to the latest version right as I press the button to send the update.

So I think I have to right idea, but how would I update the record before sending it?

Right now on select on the send button I have "SubmitForm([nameoftheform])"

I'd like it to be "[Function that updates record];SubmitForm([nameoftheform])"

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
One question, why do you want to update the record before update the record?

Was this reply helpful? Yes No
msabau 270 on at

Like
a
(0)

Report
Copy link

Link copied!

Because concurrency.
Let's say there are two users, user one and user two.

User one opens the record in edit mode.
User two opens the same record, makes changes and then updates the record.
User one, makes changes, updates the record, but an error pops up saying "Data is not aligned" or something along those lines.

Updating the record before sending the current change would make sure that you are always working on the latest version

Was this reply helpful? Yes No
JasonZF 572 on at

Like
a
(0)

Report
Copy link

Link copied!
Perhaps try refreshing the data source before submitting the form?
Refresh('Data Source Name');SubmitForm(Form1)

Was this reply helpful? Yes No
victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Understood, are you using a form or Patch() to update the record?

Was this reply helpful? Yes No
msabau 270 on at

Like
a
(0)

Report
Copy link

Link copied!

Since the application is tied to a very large Sp List (280 fields roughly), I'm using 4 forms that are bound to a single hidden Master Form, so when I send the update, in reality it patches the 4 forms together and then it is sent a single form

Was this reply helpful? Yes No
msabau 270 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm trying this as we speak, but Power Apps is really slow to load with these large apps. It's not so slow to load the environment, but when I select, let's say, a button, it takes a long time to load its properties, eg. OnSelect.
Also I never had any succes with using Refresh() in the past. It doesn't seem to do anything. It might also be due to the fact that the collections are cached locally because they contain more than 2000 records, so I did a series of ClearCollect() to gather all the data I need

Was this reply helpful? Yes No