Alteryx runs successfully anytime

Question

I have an Alteryx workflow that updates a SharePoint library file.
Sometimes, when running the workflow, it reaches the error of “Unable to create backup”. I figured that when someone is Editing in Excel Online, Alteryx runs to this error message.
However, the customer asks to have a solution that can update the file anytime they need. Because when and who will use Edit the SharePoint library file online is not under their control.
Is there any solution that can run the Alteryx workflow and update the output file no matter what?
Or do you have any suggestions to improve the solution?

And now I use the Alteryx server to auto-run this workflow every hour.
In the SharePoint library, the server saved too many files, such as ZAS-43fa-5c83-a8bd-99ba, ZAS-4db6-950c-e1ce-e306..
Any way I can stop the server save this kind of files to the SharePoint library?

dougperez · Answer

I don't think that is possible, even with another application.

In this case your customer  should have an application that let the user input values into a database (not an excel file), with this you can archieve that.

In the worst scenario, I would try MS Access to be this "database"

LEXQ2005 · Answer

@dougperez

Sorry, I did not mention in the initial post that the output file is also the data input file for the Alteryx workflow. The project not only expects the users to see the output result, but also expects to receive users' editing, and take in the changes made by the users in the data input.

dougperez · Answer

Hello!

I don't think you can actually update an excel file while it is open by another program... I would try use external data connectors into excel (Alteryx just updating this external) or an app (users extracting the excel file in the Alteryx Server instead of sharing that in Sharepoint)