Automate SQL Databases with Microsoft Power Automate Desktop

Рет қаралды 23,361

Күн бұрын

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: drive.google.com/drive/folder...
👨‍👩‍👧‍👦 Get Power Automate help and network with 7000+ RPA developers in my FREE Discord community: / discord
📺 VIDEOS FOR YOU
- How to Get Started with SQL Server Management Studio: • How to Get Started wit...
- Excel and DataTables in Power Automate Desktop: • Excel & DataTables in ...
RESOURCES (AFFILIATE LINKS)
👨‍💻 Learn Power Automate Desktop as a Beginner: • Power Automate Desktop...
📖 Best Power Automate Desktop Book: geni.us/FZQlmt
👨‍👩‍👧‍👦 Developer Community: / discord
👨 PAD Facebook Community: / 754059285247921
💼 PAD LinkedIn Group: / 12566435
📜 PL-500 Microsoft RPA Preparation Guide: • PL-500: Microsoft Powe...
► LinkedIn: / andersjensenorg
► Instagram: / andersjensenorg
► Facebook: / andersjensenorg
► Twitter: / andersjensenorg
► Email Newsletter: andersjensen.org/email-newsle...
⌚ 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

Пікірлер: 29

@andersjensenorg Жыл бұрын

Thanks for all your likes and support 🙌🔥 Remember to watch the previous lesson: How to set up a SQL database: kzfaq.info/get/bejne/fc-hpNKhp7nTeKs.html

@ayobamiologun9184 3 ай бұрын

I've been looking something like this where Power Automate connects to a database; and I'm really impressed with this video. Thank you.

@andersjensenorg 3 ай бұрын

Looks like Power Automate is playing matchmaker between databases and users 😀 Kind regards, Anders

@shaunrowley7230 Жыл бұрын

Another excellent video that has given me an idea for a project where i set up postal contacts list as an SQL database and then using Power Automate for Desktop can extract the data for example addresses for christmass cards write these to an excel sheet then automate my Dymo label printer software to load a label template and the excel data to print out the labels to attach to my christmas cards to post. For those that run a club etc. could use in a similar way. Thanks again 👍

@andersjensenorg Жыл бұрын

Thanks a bunch the the kind words, Shaun. Please let me know, what you'll build in the coming ❤️😊 Best regards, Anders Ps. Impressive Power Automate journey you're on!

@hotelranimahaljaipur9380 Жыл бұрын

Can you pls give us a comparison vedio between uipath vs PAD vs A360 ? I would love to have that? Also I'm curious to know about career and scope in RPA developer

@andersjensenorg Жыл бұрын

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 7000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders

@dion4894 Жыл бұрын

Can you make a video how to achieve this using the SQL connector in Flow? I can't seem the make a right connection with a SQL database using the Flow SQL connector.

@andersjensenorg Жыл бұрын

@fatikelmaswegho1354 9 ай бұрын

Hello Mr Jensen, Thank you so much for the video but i am still confused. Can you please assist with a flow that loads csv files from a folder into a sql table? where the file already exist in the sql table, skip else create records in the sql I am able to successfully load 1 file but cannot iterate through several because it will not let me link the columns through indexing

@andersjensenorg 9 ай бұрын

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders

@sanketsingh1735 Жыл бұрын

Is there any way to connect to oracle data base without the connector given in cloud flow like can we connect to oracle db from desktop flow if yes how ?

@andersjensenorg Жыл бұрын

If you can access it through an API call, yes 🙂

@MindyBrockdesigns 5 ай бұрын

Is it possible to create an automation cloud flow in power automate to copy data from table A to table B in SQL server? Reason being, going from a Microsoft form to SQL creates it’s own ID’s. But I want to coincide with data entries already in table B and set the ID field to identity key field.

@andersjensenorg 4 ай бұрын

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders

@jameerbasha5785 Жыл бұрын

we can get connection postgresql server in power automate desktop ?

@andersjensenorg Жыл бұрын

@cristobalramirezvalderrama790 4 ай бұрын

hi master, can i connect power automate desktop with DB posgres?

@andersjensenorg 4 ай бұрын

@suraj_singh321 Жыл бұрын

Hi Anders sir make a video on SharePoint actions in PAD

@andersjensenorg Жыл бұрын

Hey Suraj. Thanks a lot for the suggestion. I will do it, since they're out of preview. Have a great day. Kind regards, Anders

@suraj_singh321 Жыл бұрын

@@andersjensenorg sir you need to take 30 days free trial than it will open it is paid

@andersjensenorg Жыл бұрын

@@suraj_singh321 I already have, thanks a lot 🙂

@user-sx5iw9pq8i Жыл бұрын

Hi How to Integrate Uipath Studio with Power BI Can you make a video

@andersjensenorg Жыл бұрын

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders

@user-sx5iw9pq8i Жыл бұрын

@@andersjensenorg Thankyou😀 I have Join the Community

@mdhidayat5706 Жыл бұрын

Though I am comfortable with SQL, I hope we get a GUI wizard where we can filter datatable easily in the future. Something like Uipath. These SQL syntax tend to scare business people 😅

@andersjensenorg Жыл бұрын

I agree. It would also make my life easier 😄 Today I had a meeting with the product team from Power Automate Desktop. I'm under a strick NDA, but I can gurantee that big news are coming (and it's non GPT). See you soon, Md 🙌

@mdhidayat5706 Жыл бұрын

Looking forward to it. 💯👍