Power Automate Desktop || Module 7 :Database Actions with Stored Procedure

[@fabianaltendorfer11]

That's a really helpful video!

[@TheKalipolis]

This is fantastic! thank you so much. So, if I want to upload the full file into a new table, I just add a step "Truncate table" and then something like "Insert into SQLTableX select * from %ExcelData%"?

[@rahulraj89]

Very Nice Could you please make a video for Outlook and Teams. If I have received a mail want to notify through the team.

[@niftyoptionslivetradingand7231]

Excellent video, I created the same table provided in excel and on SQL server I made an SP and a table and have been following your step by step process but since morning I am stuck with one error when running the SP it says "Cannot convert character to date format" for the DOJ column in excel. When I change the data type of DOJ column in the SQL Server for HR Process table from Date to varchar only then it is running ok, otherwise no matter what modification I make to the excel DOJ format the SP is giving me same error if Date data type is maintained in the SQL server database, can I please request your advise and help on this...thanks a lot wonderful videos fantastic and keep it up....ALL THE BEST....

[@brijendraydv]

Thanks, how do we deploy or schedule the workflow?

[@gagansingh3481]

Sir once we all the rows gets inserted into data base and next day if we append new data shall this flow work. I MEAN INSERT NEW ROWS OR IT INSERT THE DATA OLD LINES ..OR I HAVE TO EDIT READ ME ACTION AND GIVE THE NEW RANGE

[@videmkoo]

Hello, Thank you for a great video. One thing that bothers me is how to insert data into MS Access Database?

[@LearningTechnologies]

There is a video series started on excel as a database. Please check that once

[@mellocamilo]

Great video! I have just one question: At the Excel file reading step, how to tell that the final row will be calculated instead of a fixed row value?

[@LearningTechnologies]

Get or Count the number of rows in excel table. And pass the last row value dynamically

[@nocodeyuan]

Great video! But is it possible to insert the whole table into SQL in one go? Supposing insert row by row is not efficient for large dataset.

[@LearningTechnologies]

Yes you can! But the data has to pass to sql in table format (@datatable Parameters by using Stored procedure)

[@eudogarcia7426]

@@LearningTechnologies I tried this solution with a table type variable in an stored procedure but I'm having issues executing the stored procedure sending my local datatable variable, can you make a video with the same solution but using datatable variable?

[@GamingBot_1]

I created the same flow but the flow is not working and showing error. If i put single quote then it is showing error of conversion nvarchar to date and if i do not keep single quote then it is showing error as Error in SQL statement Incorrect syntax near '.'.. Please help to resolve this.

[@vijaykumarsingh8662]

Sir Please tell me how i can run stored procedure Created in MySQL WORKBENCH IN POWER AUTOMATE ' s database execute query part

[@sabirismail4654]

How can i do an insert without a tored proc straight into sql from excel using power automate?

[@soundaryaguduri3506]

Hi sir, i have executed as you said. but how to add headings

[@vijaykumarsingh8662]

Respected Sir please tell me in this step you are telling we can insert data in database through sp via reading excel sheet but my problem is what I can do if excel have many Duplicate rows but I want to insert the data in data tables are unique not repeated . Please reply me back please

[@priyadarshini1405]

How identify excel last row dynamically?

[@priyadarshini1405]

There is no separate condition within excel action to identify row count