How to check if file in SharePoint is opened by another user?

[AdityaJain]

Hi All,

I want to check if a excel file in SharePoint is opened by another user. Anyone have any suggestion on this? how can we check this in Blueprism?

------------------------------
Aditya Jain
RPA developer
Accenture
Asia/Kolkata
8058426934
------------------------------

[steven.boggs]

Hi Aditya,

There's not a way to do this out-of-the-box in Blue Prism, but it should be possible to create a VBO that utilizes a code stage that can check if a file is already open. This StackOverflow article has some VB code suggestions that may work for this.

Alternately, if others here have suggestions for how to perform this type of check with the existing SharePoint VBO(s) on the DX and/or functions within a custom VBO, hopefully they can share them in this thread as well.

------------------------------
Steve Boggs
Senior Product Support Engineer
Blue Prism
Austin, TX
------------------------------

[ManpreetKaur1]

Hi @Aditya Jain,

As suggested by @steven.boggs, code stage is the best way to check if the file is already open or not. There is no inbuilt functionality which is being provided by Blue prism to check it.​​

------------------------------
Manpreet Kaur
Manager
Deloitte
------------------------------