Unanswered

Locking a form so only one user can edit at a time

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

I was wondering is there a way to lock a form so that only one user can edit it at a time, and any other users who try to access the form will receive a notification that someone is already editing this form? For example, user A is editing a form and user B tries to access the same form, user B will not be able to access the form and will be notified that someone else is editing it.

At the moment, I have a screen with a gallery of items with an arrow button. When someone clicks on this arrow button, it navigates them to the form for that specific item. Is there a way in which I can disable the submit button on the form for user B, or else just not let them access the form at all if someone is already editing it? I have seen 1 or 2 posts about this previously but was unable to make any sense on how to actually go about implementing their solution.

Thanks,

Jack.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

WarrenBelz 155,283 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

When the item is selected from the gallery, set a Variable (OnSelect of the Gallery before your other code).

Set(gblRecord,ThisItem)

Then on the Save function before your save action

If( LookUp( SPListName, ID = gblRecord.ID ).Modified <> gblRecord.Modified, Notify( "This record has been modified since you opened it", Error ), YourSaveActionHere )

This checks that the modified time/date when the user opened it is still the same (or not)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
WarrenBelz 155,283 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
harryh6 19 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz
I tried using your solution and it gave me this error.

Was this reply helpful? Yes No
WarrenBelz 155,283 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@harryh6 ,

No error in a test (see below) - the code is valid structure

You might also try a Capital U in LookUp

Was this reply helpful? Yes No
harryh6 19 on at

Like (0)

Report
Copy link

Link copied!

Thank you 🙂

Was this reply helpful? Yes No