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
Смотрите видео UI Automation: Get Excel files in folder, enter data in app & write results back to Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь MS Power Automate 22 Июль 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,834 раз и оно понравилось 55 людям.