Скачать с ютуб Advanced Excel in Microsoft Power Automate Desktop - Use Case for Accountants в хорошем качестве

Advanced Excel in Microsoft Power Automate Desktop - Use Case for Accountants

This advanced use case shows how to work with Excel in Microsoft Power Automate Desktop. We're solving an RPA process for accountants, where we want to extract web data to Excel and automate and manipulate it in Excel. 📂 Download the course materials: https://andersjensen.org/microsoft-po... VIDEOS FOR YOU: 🔹 Save Web Data to Excel - Power Automate Desktop Advanced Use Case:    • Save Web Data to Excel - Power Automa...   🔹 Power Automate Desktop For Beginners (4.5+ hours):    • Microsoft Power Automate Desktop For ...   POWER AUTOMATE DESKTOP GROUPS: 👨‍👩‍👧‍👦 Discord:   / discord   - Join my network with 4000+ Automation/RPA developers, where we solve Automation/RPA problems, network and help each other upgrade our careers. It's free! 👩🏻‍🎓 LinkedIn:   / 12566435   👨🏻‍💻 Facebook:   / 754059285247921   FOLLOW ME: 💼 LinkedIn:   / andersjensenorg   📸 Instagram:   / andersjensenorg   👨 Facebook:   / andersjensenorg   🐦 Twitter:   / andersjensenorg   💌 Email Newsletter: https://andersjensen.org/email-newsle... 0:00:00 Intro In today's Microsoft Power Automate Desktop lesson, we solved an advanced Excel use case. 0:00:55 Extract Web Data to Excel Download the course data to a desktop folder. Save the path because we'll use it in Power Automate Desktop as a variable. This is best practice, as we can use the variable in multiple actions, and it will be easy if we move the project and need to change the path. Use a Launch Excel action to open an Excel instance and a Close Excel action to save and close it again. The Set active Excel worksheet action is used to ensure we use the correct sheet. Read the Excel data into a DataTable. For each row in the DataTable, we want to do an internet search based on the values in a column, extract the web data and save it to DataTable and then Excel. The data we want to save is currency data from the Danish National Bank. Using the Extract data from web page action lets us automatically extract the currency data into a variable. Then, we can write the data to the Excel sheet with a Write to Excel worksheet. 25:21 Using Subflows It's best practice to use subflows in Power Automate Desktop. We do it to keep our projects organized. 29:40 Advanced Excel Accounting This part teaches you a lot of advanced Excel in Power Automate Desktop. We'll practice DataTable work, referencing, lookups, and manipulating data for each row of Excel sheets/tables. It targets accountants, but everyone can learn much from the use case. When you want to do calculations on Excel data, remember to convert the data to numbers, even though it looks like numbers, e.g., a Convert text to number action. 47:46 Four Eyes Check Based on the values in the Excel sheet, our Power Automate Desktop process will send email warnings to the compliance department if the values are significant - a four eyes check. Send an Outlook email message with the Send email message through Outlook action. 52:52 Error Handling We can make very advanced error handling in Microsoft PAD. For example, here, we check for a blank value, meaning we can't do a calculation. #powerautomate #powerplatform #office365