Power Automate Desktop || Module 6 : Database (Open and Close SQL Connection, Execute SQL Statement)

Рет қаралды 44,225

3 жыл бұрын

#powerAutomatedesktop #microsoftpowerAutomatedesktop #powerAutomate #microsoftpowerAutomate #RPA
In this Module,
we will learn different Database Actions
1) Open SQL Connection
2) Execute SQL Statement
3) Close SQL Connection
Microsoft Power automate Tutorials for Beginners
Module 1 : Introduction To Microsoft Power Automate • Microsoft Power Automa...
Module 2 : Sign up and sign in for Power Automate • Microsoft Power Automa...
Module 3 : Create a FLOW in Power Automate by using Templates • Microsoft Power Automa...
Module 4 : Build a first FLOW in Power Automate • Microsoft Power Automa...
Module 5 : Build a flow to connect Microsoft SQL Server • Microsoft Power Automa...
Module 6 : How To create and Use of Team Flows • Microsoft Power Automa...
Module 7 : Introduction to UI Flows Using Power Automate • Microsoft Power Automa...
Module 8 : Working with Connectors • Microsoft Power Automa...
Module 9 : How to Create An Approval Workflow (30 min- Detail) • Microsoft Power Automa...
Module 10 : Run a flow on schedule || Recurring Flows • Microsoft Power Automa...
Module 11 : Create a Manual Flow or Instant Flow • Microsoft Power Automa...
Module 12 : How to Export and Import Flows • Microsoft Power Automa...
Module 13 : Team Flows • Microsoft Power Automa...
Module 14 : Submit a flow as Template • Microsoft Power Automa...
Module 15 : Create a Flow On Mobile || Power Automate MobileApp • Microsoft Power Automa...
Module 16 : Overview of Connectors • Microsoft Power Automa...
Module 17 : Triggers & Actions of Connectors • Microsoft Power Automa...
Module 18 : UI Flows - Win Automation and Selenium IDE • Microsoft Power Automa...
●Please Subscribe Here to learn more about RPA➤
kzfaq.info...
●Join #DevOps and #RPA Face Book Group for updates➤ / 166692824556293
Thank you for Joining With us.
As Always, Please do Like, Subscribe and comment.
To Support through Donations: www.paypal.me/learningtechnol...

Пікірлер: 62

@manojk6258 3 жыл бұрын

How to connect oracle database?

@bhaveshzala9006 2 жыл бұрын

Thanks for such a nice informative video, to the point...

@vijaykrishnan4151 3 жыл бұрын

The column headers are not transferred to Excel , how to do that?

@mohamedatallah7845 2 жыл бұрын

Very nice example, Keep going :)

@LearningTechnologies 2 жыл бұрын

Sure , with all your support. Thank you Mohamed Atallah

@amminenikiran3509 3 жыл бұрын

Here I can see only we are copying data present in the table, Can we copy with columns headers as well ???

@pashupatimishra9335 3 жыл бұрын

Awesome

@LearningTechnologies 3 жыл бұрын

Thank you

@brijendraydv 3 жыл бұрын

Thanks this is really helpful and it works the way i wanted however how can i schedule this as the saved flow is not appearing in cloud?

@luisfmts 2 жыл бұрын

Very usefull

@LearningTechnologies 2 жыл бұрын

Thank you

@sarveshnundram866 3 жыл бұрын

Hi Mr Ameer - What if we want query result to be written on different rows? for example ID 1 on cell B1 and ID 2 on cell Z1 ?

@shahjehanmukoon7442 3 жыл бұрын

can we have the column name as well when importing sql result to excel?

@habimuc8959 2 жыл бұрын

Hi sir, thanks for this clear description. I‘ve the problem, that the query results is exporting in one cell of excel, not the single database field in single cells of excel. Any idea? Thanks for your reply. HaBiMuc

@Boomtiger47 3 жыл бұрын

So the only option is to write the query into an excel file? I was hoping to assign data from the query into their own variables within my desktop flow. That way I can have the flow paste this data into certain fields of my legacy system.

@v75tan 3 жыл бұрын

how for data table - I need to manipulate i.e. filtering, sorting, adding, manipulating some columns data in it, even creating new data table from the previous data table, adding new rows in the data table, etc.

@Lennings82 2 жыл бұрын

if i have a internet domain that host my webpage. and in may domin i have a database with all the users that can log in. can i connect to this database over the internet?

@sajjadul 2 жыл бұрын

Ameer, how to write the column header in excel output?

@Lennings82 Жыл бұрын

hi. Is it possible to use one sql output in another sql? like SELECT * FROM %query%

@diazjubairy1729 Жыл бұрын

Does this tutorial works also for connecting sql server in virtual machine to power automate ?

@samikpal3583 3 жыл бұрын

Thanks for this. Is it possible to write the Query result in a csv file instead of excel. Excle has row limitation and I have large table that would surpass the limitation unless I can write the output to a csv file. Many thanks in advance.

@swankyshivy 3 жыл бұрын

do you have opposite? excel to sql server or ms access db?

@wagwewaltz5748 8 ай бұрын

Excellent presentation. Your data was extracted to excel without table headers. How can that be added

@Truthhurt419 Жыл бұрын

Thanks for video. While exporting it's not including header. How can we handle this ?

@chetanvasantrote7646 3 жыл бұрын

Hi Ameer, You are doing a great job. I am learning Power automate through the videos you have created Thanks for the great videos. I had 1 question Can we update the Microsoft dataverse table from the Desktop Flow?

@haameemshimar8828 2 жыл бұрын

iam using the power automate for the first time.is the power automate free for oracle database connection??

@sohilsanghavi774 7 ай бұрын

Hi Ameer, When I try to connect to SQL DB, it gives message as "The select permission was denied on the object '[table name[' , database [databasename], schema[dbo].". Any help would be appreciated thanks.

@sowmya9710 2 жыл бұрын

Hello , thank you for the clear explanation. Can you kindly provide on how will be the CONNECTION STRING , using "sql server authentication" . Also have SSMS installed , do we need to install any more softwares for this process , using sql server authentication in this desktop flows? Kindly suggest.

@sowmya9710 2 жыл бұрын

Hello, can you please provide an example for the connection string as i mentioned.

@TheKalipolis 3 жыл бұрын

Hello! Thank you so much for your videos. Do you have one where I can import an Excel file into a SQL database?

@LearningTechnologies 3 жыл бұрын

Let me check

@rajenderreddy5035 2 жыл бұрын

"Error in SQL statement The Microsoft Access database engine stopped the process because you and another user are attempting to change the same data at the same time". getting the above error while updating the excel column and file needs to be in open state. ANy idea how to overcome this issue

@mattongbp 3 жыл бұрын

How to insert into the DB from the excel file?

@stevencleves8992 3 жыл бұрын

Thank you for your video! I have a problem to connect a MySQL Workbench Database to Power Automate Desktop. Can someone help me out?

@LearningTechnologies 3 жыл бұрын

Sure. please share the details Steven

@stevencleves8992 3 жыл бұрын

@@LearningTechnologies How do I typ in in the connection string the port number? For Example: Database = Data01 Port =3332?

@tedwow2625 2 жыл бұрын

same problem here... :(

@sanjaynoudiyal9467 3 жыл бұрын

Thank you so much sir for explaining everything as easily to make understand us. Sir i need your help once, I usually fatch the data manually from a software to excel. So I am unable to understand it how it can be automated. Sir please let me know best ways for this. Regardless - Sanjay.

@LearningTechnologies 3 жыл бұрын

Sure I will help you

@sanjaynoudiyal9467 3 жыл бұрын

@@LearningTechnologies sir how can I connect with you and when you have time? Please confirm once. Thank you so much.

@LearningTechnologies 3 жыл бұрын

You can Contact me on my email ID.

@sanjaynoudiyal9467 3 жыл бұрын

Sir please share your mail id. Thank you.

@LearningTechnologies 3 жыл бұрын

basha.ameer86@gmail.com

@purushottamw Жыл бұрын

How do we keep the Header in excel while getting data from SQL?

@rajesh123sharma1 3 жыл бұрын

Hi I am facing the runtime error

@LampattheDoor 3 жыл бұрын

Thanks for this. I can't seem to find how to get/download the power automate desktop app. Can you (or anyone) recommend a link?

@LearningTechnologies 3 жыл бұрын

Go through this kzfaq.info/get/bejne/m8iVg9iA1tKrdHU.html

@kvniranjan12 3 жыл бұрын

Can I connect to Oracle database?

@LearningTechnologies 3 жыл бұрын

Yes we can . We need to use oledb providers

@kvniranjan12 3 жыл бұрын

@@LearningTechnologies Tried it...but not able to connect...Will be helpful if we have a video sir

@Johann75 Ай бұрын

Nice, but works extremely slow for me and Close SQL Connection does not work. Also, cannot save the flow.

@raphaelbonillo2192 3 жыл бұрын

How can I send an email when a new record is created on SQL Server table?

@LearningTechnologies 3 жыл бұрын

Yes possible

@raphaelbonillo2192 3 жыл бұрын

@@LearningTechnologies It would be wonderful if you did that! Ha, ha! Your job is fantastic. Congratulations!

@gustarinanurfadilah2436 2 жыл бұрын

How to Install Microsoft SQL Server Management Studio ?

@LearningTechnologies 2 жыл бұрын

kzfaq.info/get/bejne/p-ChnNiBprWXlZs.html

@gustarinanurfadilah2436 2 жыл бұрын

@@LearningTechnologies thank you so much

@LearningTechnologies 2 жыл бұрын

Welcome

@fernandomallorua1702 3 жыл бұрын

Please, can you add subtitles for this video?

@LearningTechnologies 3 жыл бұрын

I will try Fernando

@VidhiGohel-b4o Ай бұрын

How to connect Database with SQL server Authentication (Login id and password)