Automating reruns of processes

[DevrajSingh123]

Hi

Im looking to automate the re-running of our Blue Prism processes whether there is a time out or something has gone wrong. 

Our processes write data to a SQL database so technically using that SQL table we can see and direct where things go wrong by manually checking these tables. 

We have 7 resources we can run processes on and we use the schedule and scheduler for this.

my goal is to have a power app in where I can click a button and it will rerun the process I have specified. 

can it be done? 

[harish.mogulluri]

Hi @DevrajSingh123 

I want to ensure I fully understand your question.

Currently, your automation or processes are logging exception information into a separate SQL database table (assuming this is not the default Blue Prism database that stores BP-related data). This table is specifically used by your team to capture exception details from the process.

Now, in case of a failure, you want to trigger an automation using Power Apps. Is that correct?

If that is the case, It can be doable but there are lot of nuances around it

If your SQL Server is on Prem and want to connect directly to power Apps( You must  have Datagateway  installed to ensure the data flow between SQL Server to power Apps) 

There are multiple options present but it all depends on whether you want real time data flow between SQL to Power Apps   or want  data flow hourly from SQL to dataverse and eventually connect Dataverse to power Apps 

If you're simply looking to determine whether Power Apps can trigger a Blue Prism process—the answer is yes! There are three different ways to achieve this.

High-Level Overview of the Flows:

You can create a basic Power Apps form with a dropdown or text box to specify the Blue Prism process to be triggered. This form can have multiple fields, depending on the chosen approach.

1) Using Blue Prism APIs with Power Automate

Once the Power Apps form is submitted, you can connect it to Power Automate (either cloud or desktop) to call the Blue Prism API and trigger the process.

Prerequisites:

• Blue Prism Hub and the API endpoint should be enabled.
• Refer to this Blue Prism Digital Exchange for more details.

2) Using Azure Functions to Invoke Blue Prism Processes

You can create an Azure Function following the steps outlined in this link  Blue Prism Digital Exchange and then create a custom connector to trigger the Blue Prism process.

Flow for this method:

1. The Power Apps form submission triggers a Power Automate cloud flow.
2. This cloud flow calls the custom connector.
3. The custom connector triggers the specific Blue Prism process, which must be exposed as a SOAP API.

Note: Instead of exposing all processes, You can expose one process and trigger the process via SOAP API and this process will trigger other 

3) Polling Data from SharePoint via the Graph API

If you prefer not to use APIs or custom connectors, you can:

1. Submit the Power Apps form, which adds an entry to SharePoint.
2. A Blue Prism process periodically polls SharePoint for new entries.
3. When a new entry is found, Blue Prism triggers the required process using the command line or another alternative method.

This approach allows Power Apps to trigger a Blue Prism process indirectly through SharePoint.

I have written an article on this one. It will be out in a few days in case if you need more details and information,


Thanks,
Harish