Automate SQL Databases with Microsoft Power Automate Desktop

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

📺 VIDEOS FOR YOU

RESOURCES (AFFILIATE LINKS)

⌚ 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

[andersjensenorg]

Thanks for all your likes and support 🙌🔥

[ayobamiologun]

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

[pramilakumari]

Amazing video.. This is really very helpful

[shaunrowley]

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 👍

[cesarjuarez]

Hi, Anders, I need an example of connecting to an Oracle database and executing a stored procedure. I can't execute the stored procedure

[fatikelmaswegho]

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

[hotelranimahaljaipur]

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

[sanketsingh]

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 ?

[MindyBrockdesigns]

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.

[jameerbasha]

we can get connection postgresql server in power automate desktop ?

[cristobalramirezvalderrama]

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

[dion]

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.

[SUVAMGUPTA-kv]

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

[suraj_singh]

Hi Anders sir make a video on SharePoint actions in PAD

[mdhidayat]

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 😅