In this video tutorial, you will learn how to use Power Automate Desktop to automate reading and looping Excel files. You'll also discover how to use this data to perform web searches, web scrape and then write the results back into Excel. This hands-on, step-by-step approach is tailored for beginners and ensures that even those new to automation can easily follow and implement the techniques demonstrated.

TOP LEARNINGS
🔹 Learn to read and loop Excel spreadsheets using Power Automate Desktop
🔹 Discover how to use Excel data to perform accurate web scraping
🔹 Master writing web results back to Excel

By the end of this video, you will have a solid understanding of how to leverage Power Automate Desktop to enhance your data processing tasks. You will be fully equipped to read data from Excel, search for information online using this data, and efficiently write your findings back to Excel. This straightforward guide is designed to give you the confidence to apply these skills in your daily tasks and improve your productivity significantly.

📚 LINKS FROM THE VIDEO
Download the Excel sheet used: https://drive.google.com/drive/folder...

👨‍👩‍👧‍👦 Get Power Automate help and network with 12,000+ RPA developers in my FREE Discord community:   / discord  

📺 VIDEOS FOR YOU
Save Web Data to Excel (Advanced):    • Save Web Data to Excel - Power Automa...  
Excel and Data Tables in Power Automate Desktop:    • Excel & DataTables in Power Automate ...  

RESOURCES (AFFILIATE LINKS)
👨‍💻 Learn Power Automate Desktop as a Beginner:    • Power Automate Desktop for Beginners  
🥇 Power Automate Best Practices:    • Power Automate Desktop: Best Practice...  
📖 Best Power Automate Desktop Book: https://geni.us/FZQlmt
👨‍👩‍👧‍👦 RPA Developer Community:   / discord  
👨 PAD Facebook Community:   / 754059285247921  
💼 PAD LinkedIn Group:   / 12566435  
📜 PL-500 Microsoft RPA Preparation Guide:    • PL-500: Microsoft Power Automate RPA ...  

► LinkedIn:   / andersjensenorg  
► Instagram:   / andersjensenorg  
► Facebook:   / andersjensenorg  
► X:   / andersjensenorg  
► Email Newsletter: https://andersjensen.org/email-newsle...

⌚ TIMESTAMPS
00:00 Introduction
00:38 Read and For Each Excel
05:48 Access a specific value in each row
07:42 Do web searches from Excel
13:03 Web scrape and write to Excel
21:37 Update data table
25:30 Best practices

#powerautomatedesktop #powerautomate #excel