Solved: Lock a sharepoint list item form for only one user to edit at a time

Hi All,

I have a form in powerapps database is sharepoint list. I want to make sure only one person can edit a form at a time.

I know I can try to make a variable and set its value every time a person edits it. But what if the person closes the browser directly how do we reset the variable at such situation.

Categories:

Using Apps Using Formulas

Hi @Shweta_Nayak ,

I assume that user A is using form. So user B cannot use form at this time.

You could use the Timer control in powerapps.

The timer interval is set to 5 minute.

Execute timer every 5 minutes.

Each time the timer executes this: patch the current time to the first record of a table.(I assume you have a list/table and the list/table has a Date and Time column.)

At this time, user B only needs to judge the difference between the time of the record/Item and the current time.

If the time difference is greater than 5 minutes, it means that user A has closed the browser.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.