Scenario: I have multiple excel files to be downloaded from SharePoint and have to process one by one based on requirement.
Currently i am downloading all the excel files into my local and processing each file based on the filename by using Directory.GetFiles in foreach loop, if any error occurs, i will move that specific file to log folder and process the next one. Once foreach loop ends, final mail will be sent.
As this process takes more time, thought of working the same with multiple systems using orchestrator, but haven’t got any idea on how to do that.
Can anyone help me on this?