@bsartorelli two approaches. You can list the files and create an error handling (retry the ones that failed). Also you can download them first to a local drive and then import them.
@JGebhard I wanted to build a workflow that would do a try catch anyway. It does follow the model and would try to append sheets to an existing Excel file.
In the first instance of the outer loop a _temp.table will be written that would contain the procedures and one could follow if the loop was successfil.
[image]
Within the component an inner loop would try 10 times (you could adapt that) to finish the job. A Try Catch block would check if the operation was successful and fill a Flow Varia…
Blog: Collect and Restore — or how to handle many large files and resume loops
1 Like