I followed the guide on your website, and it was perfect for what I needed to achieve. A really great explanation that was easy to follow and understand. Thank you!!
Hi Scarlett, I really appreciated this video! Exactly what I needed. I need a little help with setting a flow to clear out isEditing/EditingBy, I seem to not be able to achieve it. Can you point me in the right direction please. Thanks
Did you try to follow my article for instruction: medium.com/@scarlett.h.li/how-to-prevent-multiple-users-from-editing-the-same-record-simultaneously-in-power-apps-31a2ca572449
how about if your data source is an excel file stored in a sharepoint? how can we add IsEditing and EditingBy column with those settings that you mentioned?
There are a couple of ways to tackle this. You can set a timer, make it visible = false. Trigger it when user clicks edit button and set say an hour or two then save and patch the Editing back to “” to release it. There is also ways of using power automate. To ensure avoid locking a record when a user forgets to unlock it, when I did is to write a simple scheduled flow that will run 7am each weekday to patch records where EditingBy is not blank to “”. That way all the records will remain unlock every day when users launch the app.
I followed the guide on your website, and it was perfect for what I needed to achieve.
A really great explanation that was easy to follow and understand.
Thank you!!
Glad it helped!
Thanks for sharing! That’s exactly what I was looking for!
Hi Scarlett, I really appreciated this video! Exactly what I needed. I need a little help with setting a flow to clear out isEditing/EditingBy, I seem to not be able to achieve it. Can you point me in the right direction please.
Thanks
Did you try to follow my article for instruction: medium.com/@scarlett.h.li/how-to-prevent-multiple-users-from-editing-the-same-record-simultaneously-in-power-apps-31a2ca572449
how about if your data source is an excel file stored in a sharepoint? how can we add IsEditing and EditingBy column with those settings that you mentioned?
I haven't tried that on excel file, You will need to explore and try it out.
What happens if they force close the app and have the record in editing? This would lock it forever for everyone.
There are a couple of ways to tackle this. You can set a timer, make it visible = false. Trigger it when user clicks edit button and set say an hour or two then save and patch the Editing back to “” to release it. There is also ways of using power automate. To ensure avoid locking a record when a user forgets to unlock it, when I did is to write a simple scheduled flow that will run 7am each weekday to patch records where EditingBy is not blank to “”. That way all the records will remain unlock every day when users launch the app.