How to read once more current sharepoint list item before update ?

[NewDev]

Is it possible to read once more the current SharePoint list item before updating it? The need is to verify if the item has been updated in the meantime and thus eventually take another action such as notify the user.

[mdevaney]

@NewDev 
The better method is to create a new column called "Locked" in your SharePoint list and check it prior to editing the record.  

When the user accesses the record check to see if its locked.  I assume you are navigating from a gallery to a screen with an edit form.

Set(currentRecord, LookUp(your_datasource_name, ID=Gallery1.Selected.ID));
If(currentRecord.Locked
    Notify("This record is currently locked for editing ,Notification.Error),
    Patch(your_datasource_name, currentRecord, {Locked: true});
)
Navigate(your_next_screen);

On the Edit screen put this code in the DisplayMode property of the submit button to disable it when the record is locked

If(currentRecord.Locked, DisplayMode.Disabled, DisplayMode.Edit)

Then you'd have a submit button with this code in OnSelect

SubmitForm(your_form_name)

Finally, use this code in the OnSuccess property of your Edit Form

Patch(your_datasource_name, currentRecord, {Locked: false});

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[NewDev]

Your assumptions are perfectly correct. Wouldn't a timestamp be better? I could check if the item I'd like to edit/update is still the same or has changed in the meantime. Otherwise when would the locked column be set and unset?

[mdevaney]

@NewDev 
Yes, I think you are right...

Maybe you could put this code in the OnSelect property of the gallery where you choose the record to edit.

Set(currentTime, Now());
Set(currentRecord, LookUp(your_datasource_name, ID=Gallery1.Selected.ID));

Then put this code in the OnSelect property of the Submit button.

If(
    LookUp(your_datasource_name, currentRecord, Modified) < currentTime,
    SubmitForm(Form1),
    Notify("Record was already modified by another user")
);

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[mdevaney]

@NewDev 

Did I answer your question here?  Please let me know.