Blue Prism to Sharepoint List

[joeknibbswm]

Hi

Is there any easy process to build, or even a template process to extract queue report data from Blue Prism into a SharePoint list. With the intention of using this SharePoint list to create a high level dashboard (time saved, cases worked etc.) with the wider business.

Regards

[plnarayana777]

Hi @joeknibbswm ,

Check if these steps are helpful to implement,

Through Blue Prism Process

1. Create a process and schedule based on your requirement like end of the day

2. Based on requirement to append only particular queue or all queues of that env

3. Get all queue data for that particular day

4. Append the list item in share point through HTTP - Post method

Power Automate - cloud flow

1. Create a flow with schedule or trigger 

2. Using SQL (connection) excel get rows

3. for each loop (SharePoint create item )

Regards

[naveed_raza]

there are multiple ways to do this

- Blue prism process

1. built process flow to fetch data from queue and schedule it

2. using Sharepoint Graph API or using Sharepoint Connection String (OLEDB) you upload collection to sharepoint list

- SQL Server

1. If you are blueprism admin then you can get the sql server, table details 

2. built process flow to fetch data from blue prism queue via SQL connection

3. using Sharepoint Graph API or using Sharepoint Connection String (OLEDB) you upload collection to sharepoint list

- Power Automate Flow (only if you have premium license)

1. Built flow to fetch data directly from blueprism database using SQL Connection

2. insert data into sharepoint list