In my application I have a gallery of tasks that need to be completed by multiple users. Each user is to select a task, then complete it using the application. There is an issue though when multiple users select the same task.
To prevent this, when a task is selected, it patches the document library where the tasks are stored with the user's name and an "in progress" boolean value to true. Validations are then put in place to ensure that another user cannot select the same task if it is marked as "in progress" and the user name does not match.
Despite this, it is still possible for two users to select one at the same time if the second user's data source has not refreshed after the first user selected the task. In order to solve this issue, on the task selector button, it refreshes the data source, then triggers validations, then patches the data source with the user's name and the "in progress" boolean. I thought this solved the issue, but for some reason, if the button refreshes the data source first, it will occasionally patch the wrong task in the gallery.
For example, a user will select Task 1. It will refresh the data source, validate whether it is in progress or not, then patch task 3 with the user's info and "in progress" status. I have no idea why this happens but could use some assistance with the issue of preventing multiple users from selecting the same task at the same time.
