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
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.
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?
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.
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?
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.
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.
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.
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.
"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
Thanks for such a nice informative video, to the point...
Very nice example, Keep going :)
Sure , with all your support. Thank you Mohamed Atallah
How to connect oracle database?
Here I can see only we are copying data present in the table, Can we copy with columns headers as well ???
Very usefull
Thank you
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
can we have the column name as well when importing sql result to excel?
The column headers are not transferred to Excel , how to do that?
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 ?
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.
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?
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?
Does this tutorial works also for connecting sql server in virtual machine to power automate ?
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.
hi.
Is it possible to use one sql output in another sql?
like SELECT * FROM %query%
Thanks for video. While exporting it's not including header. How can we handle this ?
Ameer, how to write the column header in excel output?
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?
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.
Hello, can you please provide an example for the connection string as i mentioned.
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.
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.
Sure I will help you
@@LearningTechnologies sir how can I connect with you and when you have time? Please confirm once. Thank you so much.
You can Contact me on my email ID.
Sir please share your mail id. Thank you.
basha.ameer86@gmail.com
do you have opposite? excel to sql server or ms access db?
Awesome
Thank you
Hello! Thank you so much for your videos. Do you have one where I can import an Excel file into a SQL database?
Let me check
Excellent presentation. Your data was extracted to excel without table headers. How can that be added
Thank you for your video! I have a problem to connect a MySQL Workbench Database to Power Automate Desktop. Can someone help me out?
Sure. please share the details Steven
@@LearningTechnologies How do I typ in in the connection string the port number? For Example: Database = Data01 Port =3332?
same problem here... :(
iam using the power automate for the first time.is the power automate free for oracle database connection??
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.
"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
Can I connect to Oracle database?
Yes we can . We need to use oledb providers
@@LearningTechnologies Tried it...but not able to connect...Will be helpful if we have a video sir
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?
Go through this
th-cam.com/video/ebePuOqlGDA/w-d-xo.html
How to insert into the DB from the excel file?
How can I send an email when a new record is created on SQL Server table?
Yes possible
@@LearningTechnologies It would be wonderful if you did that! Ha, ha!
Your job is fantastic. Congratulations!
How do we keep the Header in excel while getting data from SQL?
How to Install Microsoft SQL Server Management Studio ?
th-cam.com/video/qzqiuPAO3eg/w-d-xo.html
@@LearningTechnologies thank you so much
Welcome
Hi I am facing the runtime error
Nice, but works extremely slow for me and Close SQL Connection does not work. Also, cannot save the flow.
Please, can you add subtitles for this video?
I will try Fernando
How to connect Database with SQL server Authentication (Login id and password)