cancel
Showing results for 
Search instead for 
Did you mean: 

Robotic Process Automation (RPA) – Integrate Common Data Service (CDS) with Power Automate UI Flow and Desktop App (Paint)

In this article I want to talk about the solution provided by Microsoft for Robotic Process Automation (RPA) through an example that involving Common Data Service, Power Automate and Paint… yes, you got it right, Paint 🙂

 

Let’s do some explanations first!

 

What is Robotic Process Automation (RPA)?

The Robotic Process Automation (RPA) automating time-consuming manual processes with UI flows. The RPA capability is provided by Microsoft Power Automate.
It is typically used to perform tasks on legacy platforms where integration is not possible or expensive. RPA help organisations to accelerate digital transformation projects without having to replace legacy systems or develop expensive integration solutions.

 

What is UI Flows?

UI Flows is the capabilities of Microsoft Power Automate that supports the automation of Desktop App and Web App. In both cases the steps to create an UI Flow are the same, making the configuration as a prerequisite step.

 

Prepare the Environment

To make a UI Flows on a local environment you need to perform some configurations that I report below:

1 – On-Premises Data Gateway to make possible the communication between Power Apps and the local enviroment:

 

1

 

2 – UI Flow in order to build, test and run UI Flows

3 – UI Flow browser Extension in order to build the Web App UI Flows

4 – Selenium IDE browser Extension in order to rec the UI Flows

 

Well, once you completed the configuration of the Data Gateway in our Power Platform environment and in general all steps listed, we can create our UI Flow (the various configurations are not within the scope of this post!):

 

2-1

 

First, we can open Power Automate and select UI Flows under My Flows to create it:

 

3

 

 Next, we select the Type of UI Flow, In our case we want interact with Paint and then select Desktop App:

 

4

 

Into step Set Up Inputs, we can create a dynamic text called Account Name, because we want that Paint drawing dynamically the name entered for the Account in Dynamics 365:

 

5

 

Into step Record and Edit Step, we click Launch recorder to capture all sequence of actions to execute:

 

6

 

In our specific case we must record the opening of Paint, the addition of dynamic text and the saving of the PNG file:

 

7

 

When the registration is complete we will save the UI Flow:

 

8

 

Next, we can create a typical automated flow, where the trigger is when a CDS record is created in the Account entity. In the action we will select Run UI Flow and will choose the UI Flow that we have created:

 

9

 

Finally, we will save and try the Flow:

 

10

 

Watch the final result in the following video 🙂

 

 

Hope it helps and happy 365Power’ing!

capuanodanilo.com

 

Meet Our Blog Authors
  • PowerApps Community Mentor 2018, Practicing surgeon and former Professor of Surgery, University of Illinois, Chicago.
  • I am the Owner/Principal Architect at Don't Pa..Panic Consulting. I've been working in the information technology industry for over 30 years, and have played key roles in several enterprise SharePoint architectural design review, Intranet deployment, application development, and migration projects. I've been a Microsoft Most Valuable Professional (MVP) 12 consecutive years and am also a Microsoft Certified SharePoint Masters (MCSM) since 2013.
  • My name is Timothy Shaw and I create digital solutions using the Power Platform, Office 365, and Azure SQL and handle the IT for a small company in the energy sector. When not building the future :), I enjoy playing guitar, good (or really bad!) sci-fi, Xbox therapy, and hanging with my wife and son. Twitter: @ShortForTim