• Home
  • Services
    • Retail & eCommerce
      • .NET eCommerce
      • Multichannel eCommerce
      • Mobile Apps for eCommerce
      • eCommerce Chatbots
      • Dynamics365 Integration
    • SharePoint Portal
      • Document flow
      • Request approval services
      • Staff directory and orgchart
      • Helpdesk
      • HR-services
      • Reporting and documentation
  • Projects
  • Customers and partners
  • Blog
  • Contact us
ISDK - eCommerce development, omnichannel solutions, CRM-marketing
  • EN
    • EN
    • DE
    • NL
  • Home
  • Services
    • Retail & eCommerce
      • .NET eCommerce
      • Multichannel eCommerce
      • Mobile Apps for eCommerce
      • eCommerce Chatbots
      • Dynamics365 Integration
    • SharePoint Portal
      • Document flow
      • Request approval services
      • Staff directory and orgchart
      • Helpdesk
      • HR-services
      • Reporting and documentation
  • Projects
  • Customers and partners
  • Blog
  • Contact us
RPA with Power Automate DesktopRPA with Power Automate Desktop

RPA with Power Automate Desktop

In our previous article, we talked about Microsoft Power Automate in general. In this article, we’re going to talk in more detail about Microsoft Power Automate Desktop and RPA (Robotic Process Automation), what it is, and how to set it up.

RPA is a form of business processes automation in which AI performs repetitive tasks in order to reduce the employees’ workload and free up time for more creative tasks. The idea of RPA is to record a sequence of actions and operations which later on will be performed by the automated process. For example, it can be automatic extraction of the key information from emails and documents, and forwarding it to different services, performing specific actions in a browser window, launching apps. All these actions can be done without human participation if an RPA model is correctly set up.

Users can automate their processes with Microsoft Power Automate service. This service allows creating flows of interaction with data using connectors to lots of data sources. In recent updates of this service, Microsoft enhances robotization capabilities with Power Automate’s flow subtype called UI Flows. This flow subtype allows recording users’ actions in a browser window and later play them back when certain conditions are met. UI Flow, however, is not the only RPA feature of Power Automate. Not long ago the company introduced Power Automate Desktop. It is a client’s app for installation on users’ PCs. This service allows recording and playing back various actions performed not in a browser, but the client’s apps on the server. This made the automation of repetitive actions easier and more convenient.

Power Automate Desktop installation

On the Power Automate Desktop webpage click Download free to download the set-up file and start the set-up process.

Download PA Desktop

The installation process is simple. Select the required conditions and click Install.

PA Desktop installation

After the installation is complete, the setup program suggests adding Power Automate extensions for Chrome, Edge, and Firefox browsers and start the Power Automate Desktop app.

PA_Desktop installation

After launching the app, you need to log in with your Microsoft 365 account data. Once done, you may start creating a new Power Automate Desktop flow.

How to use Power Automate Desktop

Try to create a new flow and see what is available.
In our example, we create a flow called “Hello Flow”.

Build a flow

Once the new flow is created, we see a window that has 4 main areas:

  1. Panel with available actions that can be used in processes automation
  2. An area with buttons for recording, saving, and playing back actions inside the flow
  3. Flow variables section
  4. The main canvas for adding actions

Flows designer
For example, we open “Message boxes” section, select “Display Message” action and place it on the canvas. After this, a window with settings opens automatically. We enter the heading and the message text.

Display message

Save the action, save the flow, and click the Play button to check the result.

The concept is similar to cloud Power Automate: there is a variety of actions from which you can choose, place the chosen actions on the canvas, and set them up.
In the next example, we can try something more difficult, such as launching some app and recording actions in it.
In the System section, select Run application action and place it on the canvas. Add the application path. Let it be Windows Calculator, for instance. No more additional settings or arguments specified.

Run application

Launch the flow. The calculator opens.

Calculator opens

Don’t close the calculator and select the action Click UI element in window in the UI Automation section, place the action on the canvas after launching the app.

Click UI element in window_1

Select Add a new UI element and go to the calculator. We need to record pressing a button. The recording happens with a pressed Ctrl on the keyboard. For example, let’s record pressing 2. Save the recorded action.
Note that it is possible to imitate not only left click, but also right click, double click, and so on.

Click UI element in window_2
Now let’s add a few more Click UI element in window actions to record pressing buttons. We need to automate pressing ”2+2=” to get the result ”4”. This means we need to add 4 actions of pressing a button.

Save the flow and launch it.

Calculation result

We got the expected result, so our ”robotization” of calculating a simple formula worked out successfully.
Now let’s try one more scenario. When launching cloud Power Automate flow, we want to request input parameters and send them to Power Automate Desktop flow, which in turn will be adding them to an Excel file that is stored in a separate folder on a hard drive. For example, let it be a request for a tax certificate.
To begin with, let’s create several variables in the Power Automate Desktop flow.

Add a new input variable

We add 4 variables: initiator email, number of copies (count), year, and additional information.

Variables

Next, let’s create a simple excel file that will be filled after running the flow. Just 5 columns in the table.

Sample table

Now open cloud Power Automate and install the on-premises data gateway between Desktop and Cloud.

Gataway installation

Install and set up the gateway. After this we create an instant configurable Power Automate flow that should be launched by clicking a square start button in the Power Automate Desktop flow.

Flow creation

The cloud flow is ready. Now we need to configure Power Automate Desktop flow. Add the Launch Excel action and enter the document path.

Launch Excel

Now let’s add several Write to Excel worksheet actions to fill the Excel file and use input variables, which we define in the cloud Power Automate flow.

Write to Excel worksheet

Go back to the cloud flow and launch it. Specify the input parameters.

Sample flow

As you can see in the resulting table, everything worked well.

Flow result

To sum up, Power Automate Desktop is a client’s app that integrates with the cloud Power Automate through an on-premises data gateway. Power Automate Desktop allows automating various scenarios such as mouse clicks, creating accounts in Active Directory, creating requests in HelpDesk, interaction with Azure services components, requests to web-services, and much more. Basically, with Power Automate Desktop it is possible to “robotize” almost any scenario. The potential of this app becomes even bigger when used together with could services. Start with automating some of your routine tasks to see what it’s capable of, we’re sure you will be able to assign at least some of them to a “robot”.

—
Need help setting up your Microsoft services? Feel free to get in touch with us.

The article was originally published by Andrew Braun on habr.com

Request a quote

Microsoft

Categories

  • News
  • Tech stories
  • eCommerce

Popular topics

Adjust Azure Behavior analytics Belgium berlinexpo Business Intelligence Certification chatbots COVID-19 CRM DevExpress XAF DPD Dynamics365 ecommerce events integration Linux Marketing tools Microsoft mobile marketing mobile measurement MVP nonprofit nopCommerce nopCommerceDays omnichannel open source plugin POS Regulations security SharePoint Snowplow SQL Server Store setup subscriptions web-applications Web Analytics
  • RPA with Power Automate DesktopRPA with Power Automate Desktop
    RPA with Power Automate Desktop
    3 JAN 2021 · admin
  • Microsoft Power AutomateMicrosoft Power Automate
    Microsoft Power Automate
    18 DEC 2020 · admin
  • Microsoft Power BIMicrosoft Power BI
    Microsoft Power BI
    10 DEC 2020 · admin
  • Microsoft 365 subscription plans overviewMicrosoft 365 subscription plans overview
    Microsoft 365 subscription plans overview
    19 NOV 2020 · admin
  • Microsoft Office 365 apps overviewMicrosoft Office 365 apps overview
    Microsoft Office 365 apps overview
    12 NOV 2020 · admin
  • Which mobile app analytics platform is right for you?Which mobile app analytics platform is right for you?
    Which mobile app analytics platform is right for you?
    5 NOV 2020 · admin
  • Minimum Viable Product to test your business idea quickly and with a little budgetMinimum Viable Product to test your business idea quickly and with a little budget
    Minimum Viable Product to test your business idea quickly and with a little budget
    16 OCT 2020 · admin
  • How tracking and analytics can help you maximize your mobile app marketing effortsHow tracking and analytics can help you maximize your mobile app marketing efforts
    How tracking and analytics can help you maximize your mobile app marketing efforts
    30 SEP 2020 · admin
  • User analytics: comparison of Snowplow and Google Analytics 360User analytics: comparison of Snowplow and Google Analytics 360
    User analytics: comparison of Snowplow and Google Analytics 360
    16 SEP 2020 · admin
  • Maximize your marketing efforts with user behavior analytics based on Snowplow dataMaximize your marketing efforts with user behavior analytics based on Snowplow data
    Maximize your marketing efforts with user behavior analytics based on Snowplow data
    19 AUG 2020 · admin

Projects and solutions implemented

https://isdk.pro/wp-content/uploads/Barcode-scanning-small-150x150.jpegMVP app to test an E-Commerce business idea in 3 weeks
https://isdk.pro/wp-content/uploads/GlobeIn-Shop-small-1-150x150.jpgiOS app with Apple in-app subscriptions and purchases
https://isdk.pro/wp-content/uploads/globein-box-small-150x150.jpgSubscription boxes iOS app set up for marketing campaigns
https://isdk.pro/wp-content/uploads/book-publisher-small-150x150.jpgnopCommerce multi-store for a book publisher
https://isdk.pro/wp-content/uploads/clinic-small-150x150.jpgRoutine automation with Office 365 and Teams chatbot
https://isdk.pro/wp-content/uploads/SharePoint-in-a-business-school-150x150.jpgSharePoint Online and Office 365 in a business school
https://isdk.pro/wp-content/uploads/SharePoint-for-a-DMS_ed-small-150x150.pngSharePoint 2019 Document Archive
https://isdk.pro/wp-content/uploads/nopCommerce-upgrade-case-featured-400-200-150x150.pngnopCommerce Upgrade to .NET CORE
https://isdk.pro/wp-content/uploads/Harman-JBL-ecommerce-case-featured-400-200-150x150.pngHigh-traffic eCommerce webstore Harman.club
https://isdk.pro/wp-content/uploads/Herbalife-banner-400-200-150x150.pngE-Commerce Omni-Channel
https://isdk.pro/wp-content/uploads/hr-sharepoint-trainings-home-400-200-150x150.pngEnterprise SharePoint Portal. HRM-Trainings
https://isdk.pro/wp-content/uploads/Automobile-company-sharepoint-hr-portal-400-200-150x150.pngSharePoint HR-Portal – Employee Request Approvals

Contact us

logo

“The only way to do great work is to love what you do” - Steve Jobs

Search by topic

.NET Core .NET Framework 1С Adjust Ajax Apache JMeter ARIS ASP.NET ASP.NET MVC Bootstrap Business Connectivity Services DevExpress DevExpress XAF DevExtreme ESB Google Geoservices Google Map InfoPath Java Message Service JavaScript JQuery Knockout.js Knockoutjs Microsoft Azure Microsoft Flow MS Active Directory MS SQL MS System Center Nintex Nintex Forms Nintex Workflow nopCommerce QlikView Reporting Services SharePoint Sharepoint Search Sharepoint workflow Snowplow Telerik UML Visual Studio Web Services Xamarin

Projects

https://isdk.pro/wp-content/uploads/Barcode-scanning-small-150x150.jpegMVP app to test an E-Commerce business idea in 3 weeks
https://isdk.pro/wp-content/uploads/GlobeIn-Shop-small-1-150x150.jpgiOS app with Apple in-app subscriptions and purchases
https://isdk.pro/wp-content/uploads/globein-box-small-150x150.jpgSubscription boxes iOS app set up for marketing campaigns
https://isdk.pro/wp-content/uploads/book-publisher-small-150x150.jpgnopCommerce multi-store for a book publisher
https://isdk.pro/wp-content/uploads/clinic-small-150x150.jpgRoutine automation with Office 365 and Teams chatbot
https://isdk.pro/wp-content/uploads/SharePoint-in-a-business-school-150x150.jpgSharePoint Online and Office 365 in a business school
https://isdk.pro/wp-content/uploads/SharePoint-for-a-DMS_ed-small-150x150.pngSharePoint 2019 Document Archive
https://isdk.pro/wp-content/uploads/nopCommerce-upgrade-case-featured-400-200-150x150.pngnopCommerce Upgrade to .NET CORE
https://isdk.pro/wp-content/uploads/Harman-JBL-ecommerce-case-featured-400-200-150x150.pngHigh-traffic eCommerce webstore Harman.club
https://isdk.pro/wp-content/uploads/Herbalife-banner-400-200-150x150.pngE-Commerce Omni-Channel
https://isdk.pro/wp-content/uploads/hr-sharepoint-trainings-home-400-200-150x150.pngEnterprise SharePoint Portal. HRM-Trainings
https://isdk.pro/wp-content/uploads/Automobile-company-sharepoint-hr-portal-400-200-150x150.pngSharePoint HR-Portal – Employee Request Approvals

Contact us

  • USA Austin, TX
    +1 737 2413109

    GERMANY Berlin
    +49 15233977274

    BENELUX (BELGIUM, Antwerp)
    +32 484 40 10 53

    RUSSIA Moscow
    +7 495 651 66 62

    LATVIA Riga
    +371 27869927

  • [email protected]
  • https://isdk.pro
  • https://www.linkedin.com/company/isdk/
ISDK ©2010-2020

All rights reserved.

X
Request trial hours!
Submit
ISDK website uses cookies for statistics and content. Learn more ACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.