I created this example of a connection between an executable BPMN process and RPA (Robotic Process Automation) some time ago. As described in this blog post, I had connected the BPM system „Bonita“ with the RPA system „UIPath“. Over time, new versions have been released and my examples no longer work with the current UIPath version. Since the handling of UIPath is a bit cumbersome if you only want to implement one or two mini-examples, I have now used the free version of Microsoft Power Automate instead. This makes it quite easy to create simple automations that should only run on your own desktop. There are some restrictions in the free version, but these are not problematic for the example presented here.
In the scenario under consideration, orders that are provided in the form of Excel files are to be handled by an executable process. To do this, it is necessary to transfer the data from the Excel file into the process. Without RPA, the data would have to be entered manually. This task is now performed by the bot. It reads the Excel file, converts the data into a suitable structure, logs into the BPMS, starts the order handling process and hands over the order data.