Automate SQL Databases with Microsoft Power Automate Desktop

[@andersjensenorg]

Thanks for all your likes and support 🙌🔥 Remember to watch the previous lesson: How to set up a SQL database: kzbin.info/www/bejne/fZrUoqKmd7iiftk

[@ayobamiologun9184]

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]

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

[@rajvarad7554]

Well explained with simple inputs, Thanks a lot. Your video is very relevant to beginners. Your presentation is SUPERB!!!

[@andersjensenorg]

Hey rajvarad, many thanks for the nice comment 😊👍 Kind regards, Anders

[@RJ-lf8ex]

In the real world though I would never use Power Automate….this is 100% job for SSIS

[@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!

[@pramilakumari4422]

Amazing video.. This is really very helpful

[@andersjensenorg]

Thank you so much 😊 Kind regards, Anders

[@christiancortes9777]

Great, thank you!

[@andersjensenorg]

My pleasure 😊

[@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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@khodzhaeva.malika]

Good afternoon, please tell me how to connect to Oracle

[@cesarjuarez5122]

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

[@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 13,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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@fatikelmaswegho1354]

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]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE 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]

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]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE 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]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@jameerbasha5785]

we can get connection postgresql server in power automate desktop ?

[@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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@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 🙂

[@cristobalramirezvalderrama790]

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

[@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 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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@SUVAMGUPTA-k3v]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@SUVAMGUPTA-k3v]

@@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. 💯👍