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

Like (0) Share

Report

Posted on 24 May 2021 10:13:40 by Shweta_Nayak

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

All responses (2)

Answers (1)

Shweta_Nayak 3 on 01 Jun 2021 at 07:04:43

Like (0)

Report

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

Thanks It worked for my Case.
Verified answer

v-xiaochen-msft on 25 May 2021 at 01:58:24

Like (1)

Report

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

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.