Publishing to a SharePoint Document Library

[MadeInHB]

So I was able to succesfully publish an excel file to a SharePoint 2013 doc library.

My issue now is trying to write to different sheets in the same excel file.  It appears that when Alteryx writes to the first tab, Windows SharePoint server locks that file for editing for about 10 min.  So now when the second tab is trying to be written to, the workflow errors out.

Apparently, this lock out feature can't be changed.  I was wondering if anyone had this issue and if there are any work arounds?

Thanks.

[DanM · Accepted solution]

@MadeInHB This is an interesting question and I hope my idea gets you to where you need to go. The tools that I believe will help you are located in the Crew macros that where built by an Alteryx employee. They have been useful in cases likes this, but are technically unsupported. Please see how to download here. 

https://community.alteryx.com/t5/Engine-Works-Blog/Crew-Macro-Pack-2016-Q2-Release/ba-p/26482.

A couple of tools may assist you in this process including the Label Block Until Done, Parallel Block Unitl Done, and the Wait A Minute tool. In the screen shot below, you will see that I utilized the Wait A Minute tool to accomplish what I believe will work for you. The tool will allow you to delay data going out of the tool based on a certain amount of seconds (up to 10 hours). My theory is that if you are able to filter out each sheet of data and process them one at a time with a 10 minute interval between written process to Sharepoint, you won't receive the Sharepoint errors. Hopefully this process will avoid you having to use a scheduled process (that is if you have the Alteryx Scheduler option) or to have to use a command prompt to delay the process which may be possible with the Run Command tool.

[MadeInHB]

Well this might just work.  Will have to test it out.  Thanks for the recommendation.