UI Automation: Get Excel files in folder, enter data in app & write results back to Excel
In this video tutorial, we are going to show you how to automate the following steps using Microsoft Power Automate for desktop:
00:00 Introduction
00:10 The scenario
01:04 Get all Excel files (.xls, .xlsx and .xlsm) in folder
01:54 Iterate through all the Excel files using the "for each" loop
02:26 Reading Excel data (of variable size) using "get first free row/column from Excel worksheet" and "read from Excel worksheet" actions (remember to enable the option "first line of range contains column names")
03:14 Creating a subflow to improve modularity, readability and maintainability of the overall desktop flow
03:17 Check if an app is already opened using "if window" action; if not, start the app using the "run application" action
03: 28 Perform data entry and data extraction on application using "populate text field in window" and "get details of the UI element in window" actions
03:33 How to reference the items in the current datarow
04:25 Using "run subflow" action to trigger the subflow from the main flow
04:40 Update Excel using "write to Excel worksheet" action; this requires a row counter so that we are always updating the Transaction ID into the correct row
05:45 Create another subflow to terminate Excel and AnyTellerDemo application; this subflow will be run at the start and end of the main flow
07:31 Using "move file" action to move all the processed files into a success folder
Related videos of concepts used in this video:
• Excel automation playlist: • Power Automate Desktop Excel Automati...
• UI automation playlist: • How to Interact with Windows and Appl...
Keep in touch!
Website https://mspowerautomate.com/
Twitter / msautomate
Facebook / ms-power-aut. .
LinkedIn / power-aut. .
#rpa #PowerAutomateDesktop #RoboticProcessAutomation #PowerAutomate #ExcelAutomation #UIAutomation
Watch video UI Automation: Get Excel files in folder, enter data in app & write results back to Excel online without registration, duration hours minute second in high quality. This video was added by user MS Power Automate 22 July 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,834 once and liked it 55 people.