Скачать с ютуб Power Automate Desktop: How to Read Excel, Do an Online Search, and Write the Result Back to Excel в хорошем качестве

Power Automate Desktop: How to Read Excel, Do an Online Search, and Write the Result Back to Excel

This video tutorial shows how to read data from an Excel sheet, do an online search, web scrape the results, and write it back to Excel with Microsoft Power Automate Desktop. Web automation and web scraping error handling are also covered. VIDEOS FOR YOU: 🔹 Microsoft Power Automate Tutorials -    • Microsoft Power Automate Beginners Co...   🔹 How to Work with Files and Folders in Power Automate Desktop -    • Work with Files and Folders in Power ...   👨‍👩‍👧‍👦 Discord:   / discord   - Join my network with 12,000+ RPA Developers, where we solve RPA problems, network, and help each other upgrade our careers. It's free! FOLLOW ME: 💼 LinkedIn:   / andersjensenorg   📸 Instagram:   / andersjensenorg   👨 Facebook:   / andersjensenorg   🐦 Twitter:   / andersjensenorg   💌 Email Newsletter: https://andersjensen.org/email-newsle... MY GEAR (Amazon affiliate): 🖥️ My monitor Samsung 49-inch CRG9 Curved Monitor = https://geni.us/MDpejc - If you are buying this, I can recommend the Mi Monitor Light Bar = https://geni.us/3Wwad 💡 Lights IVISII 19 inch Ring Light and Stand = https://geni.us/fVCH3IC Godox TL60 RGB Tube Light = https://geni.us/u0hxf ⌨️ Keyboard Logitech Backlit Keyboard = https://geni.us/aT0ltB 📹 Camera Sony FDRAX53-B = https://geni.us/gnAE Lenovo 500 Full HD Webcam = https://geni.us/cZS4 🎤 Microphone Rode Wireless GO II = https://geni.us/iqy0g6H Blue Yeti = https://geni.us/dDBjCB 0:00 Intro We want to read data from Microsoft Excel, perform an online search (Google), web scrape the data, and write the result back in the Excel sheet. All made by Power Automate Desktop. 1:24 The simple solution We start by creating a simple solution in Power Automate that does a static web search and scrape the data (= we'll wait by adding the Excel part). Then, use the Launch new Microsoft Edge Action to open Edge with a start URL. Next, we can send a text to our search field with a Populate Text field (it's straightforward to work with UI elements). To send an Enter click, use the Send Keys actions. Learn to use variables as well. 9:10 The complete web scraping solution with Excel Use the Launch Excel action in Power Automate Desktop to define the Excel scope and open your .xlsx document. Remember to use the Close Excel activity to prevent your Excel sheet from being locked after the automation has run. Next, read the Excel data into a DataTable with a Get first free column/row from the Excel worksheet action and a Read from Excel worksheet action. Remember to specify your Excel sheet has headers. Next, use a For Each (loop) to iterate through each Excel sheet/Data Table row. Remember to go to the start page at the start of each iteration (Go to the web page). The Write to Excel worksheet is used for writing the value to the next column (a specific cell). 19:12 Error Handling Use a Power Automate Desktop On block error to make sure an error (business exception) doesn't break the robot. #office365 #microsoft #powerautomate