This video tutorial shows how to use Power Automate Desktop to automate your SQL databases. First, we’ll set up the connection between Microsoft Power Automate Desktop and the SQL Server database. Next, we’ll do dynamic SQL queries based on input from an Excel sheet and update the Excel data afterward.
๐ LINKS FROM THE VIDEO
– Download Excel sample data: https://drive.google.com/drive/folders/1JONHm4Pw5jmU__aznW_-YaFHmg9A4X15
๐จโ๐ฉโ๐งโ๐ฆ Get Power Automate help and network with 7000+ RPA developers in my FREE Discord community: https://discord.gg/iloveautomation
๐บ VIDEOS FOR YOU
– How to Get Started with SQL Server Management Studio: https://youtu.be/GiqqopBSoHw
– Excel and DataTables in Power Automate Desktop: https://youtu.be/urFyD7QOkac
RESOURCES (AFFILIATE LINKS)
๐จโ๐ป Learn Power Automate Desktop as a Beginner: https://youtube.com/playlist?list=PLXXz88_TPiHpY_5bfeV8RAOHnBKgc-rtw
๐ Best Power Automate Desktop Book: https://geni.us/FZQlmt
๐จโ๐ฉโ๐งโ๐ฆ Developer Community: https://discord.gg/iloveautomation
๐จ PAD Facebook Community: https://www.facebook.com/groups/754059285247921
๐ผ PAD LinkedIn Group: https://www.linkedin.com/groups/12566435
๐ PL-500 Microsoft RPA Preparation Guide: https://youtube.com/playlist?list=PLXXz88_TPiHrnu0itj7At0K-xEZyl2XNr
โบ LinkedIn: https://www.linkedin.com/in/andersjensenorg
โบ Instagram: https://www.instagram.com/andersjensenorg
โบ Facebook: https://www.facebook.com/andersjensenorg
โบ Twitter: https://twitter.com/andersjensenorg
โบ Email Newsletter: https://andersjensen.org/email-newsletter
โ TIMESTAMPS
00:00 Introduction
00:24 Open SQL connection
03:00 Execute SQL statement
04:32 SQL and Power Automate Desktop Use Case
#powerautomatedesktop #powerautomate #powerplatform
