I'm trying to figure out a way to stop two people from being on the same Edit Form at the same time. So I have a gallery and when you click on the arrow it takes you to another screen where you can edit information about that specific item. The issue is we can have multiple people in the app at the same time but we don't want two people to be doing the same request at the same time. I would like for the app to disable the submit button and have a label show up that says "This item is locked by <user email>.".
Solved! Go to Solution.
The apps made in PowerApps are multiuser. They each are their own instances so it does not matter how many users use it at the same time. If multiple users edit the same record at the same time, only single one user could edit the record, the other users would face conflict error within their app.
More details about the errors type within the app when submitting the form, please check the following article:
Currently, you could re-edit the same record only when the other user saved his/her modification into the SP list.
I was able to get something very similar to this worked out. When they press the button to go into the edit form screen I have a patch happen that sends the logged in users email address to the database. Then once they are on the screen I have the submit button disappear and an unlock button appear based on the value in the database. I did bring in a gallery (that filters only the data that was clicked into) and a timer that refreshes the gallery every ten seconds. So if someone goes into the app and unlocks the edit form for the particular entry then the other persons page shows the lock button. I'm sure I may have been able to find a better solution but for what we need it for it will work.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.