This was amazing sir, its something that I have been searching for while and have not found any good video on it until now. this was so simple and very explanatory . Please do you have any video on how to extract it from a CRM software into a SQL server using power automate? and also Vinay do you have any class you teach that I can join? Thank you
Hello thank you so much for this video! Does the SQL Table value will change as well if we updated the excel table? Also can this work with multiple tabs?
Very helpful video! What would be the next steps (or do you have any videos) on updating rows that change in the excel table and those rows in the SQL data table? The flow would need to insert and update.
Hi LMC, I have a great confusion on converting data into transpose and update to SharePoint list.... Like I have rawdata in CSV which has columns of Name, Subject1, Subject 2, Subject3. and I need to update in SharePoint list which has 3 columns Name, Student and Marks...now I want to update the CSV data by getting each rows of student marks and thier subject in a column so transposed......is there any ways we can make it ... I have been trying this for so long but no idea I am getting.
Hi @majapamajapa9548, yeah we can transpose the data and then update/ patch it to SharePoint list. Can you mail your issue at lastminutescode@gmail.com with screenshot. I need to review what exactly you are trying to do. Thanks, Vinay
This is what I was looking for!!!. One question though, will this process work if my file is in SharePoint folder and the file extension is .csv? Thank you.
@@lastminutecoders thanks for your response however it seems like the file in Share Point folder must be in a table format because it requires us to provide the Table name, I have file coming in email attachment which is in .xlsx format but now I am trying to find the way to save the file in table format, can you please share if this is possible. Thanks
2 questions: 1. What if the excel file that we intend to import has huge rows i.e. 3K - 200K? Do we still use this process? It might end up taking a considerable amount of time to import. 2. How can we import the file name as well so as to distinguish data imported in between dates or times or may be different times in the same day? I use Power Automate to save excel files with the date and time of getting them. Is there any way that I can import the name as well? This video is great. Can you post similar videos wherein we can use PA to delete, modify in SQL database. Sorry, I am pretty late in your channel, hence asking these silly questions.
Point 1: Yes definitely it will take a lot of time so remember if it is one time process or a process which you want to run monthly or weekly go with this approach. Point 2: File Name can be easily extracted from file (For this you can contact me at lastminutescode@gmail.com) Thankyou, Sure in future I will cover more videos on these topics. No Questions are Silly😁
Would anyone know how to do this so that if existing data is added it doesn't do anything, but if that data doesn't exist in the sql, it adds it... I'm making a condition but it's going crazy thanks!
@@lastminutecoders so there is a column named id in the table. Id column has been declared as an uniqueidentifier, so normally when you try to insert data into this table usinng insert command, this column is automatically populated. We don't have to populate. Now when we using the flow, since this column is marked as nkt null, in the sql step we need to enter the record for id column in for each loop. What can be done to get thisfield automatically populated.
Hi Vinay I have data of 10 lakh even though after splitting it by region some regions have data more then 1 lakh can we load more then 1 lakh data from Excel to SQL server using cloud flow ( list rows present in a table limit is 1 lakh) is there any way to increase the pagination limit in list rows present in table ?
Have you tried looping? Even I have never tested this big of a scenario with Power Automate. But If we use loop and keep Get items action inside Loop, (Let's say you have 2.5 Lakh records so loop will run 3 times - First 1lakh items, then next set of 1 lakh items and finally 50k items. You will need to use filtering based on ID or Index column. If you are able to resolve this issue with this approach do let me know. I will also do some research on this.
Thanks for sharing your knowledge.... and a couple of good tips!
@@paulskelton8799 most welcome ✨
Thank you and very helpful your explanation to fix the date problem.
This was amazing sir, its something that I have been searching for while and have not found any good video on it until now. this was so simple and very explanatory . Please do you have any video on how to extract it from a CRM software into a SQL server using power automate? and also Vinay do you have any class you teach that I can join? Thank you
Thank you so much for your inspiring words✨
If you are looking for personal training you can contact me at lastminutescode@gmail.com
I was looking for this in power automate for web! Thanks!
@@Juan_ChoS awesome, most welcome ✨
Hello thank you so much for this video! Does the SQL Table value will change as well if we updated the excel table? Also can this work with multiple tabs?
Very helpful video! What would be the next steps (or do you have any videos) on updating rows that change in the excel table and those rows in the SQL data table? The flow would need to insert and update.
Very nice!
Thanks✅✨
the new data entered to excel sheet is reflected in database how to automate this ??
Awesome ! Thank you very much!
Most welcome ✨
Great video Vinay :)
Thanks Nipun 💫
Im seeing that the SQL connectors on power Automate are premium connectors, means we have to get paid accounts for this?
Hi LMC, I have a great confusion on converting data into transpose and update to SharePoint list....
Like I have rawdata in CSV which has columns of Name, Subject1, Subject 2, Subject3. and I need to update in SharePoint list which has 3 columns Name, Student and Marks...now I want to update the CSV data by getting each rows of student marks and thier subject in a column so transposed......is there any ways we can make it ... I have been trying this for so long but no idea I am getting.
Hi @majapamajapa9548, yeah we can transpose the data and then update/ patch it to SharePoint list.
Can you mail your issue at lastminutescode@gmail.com with screenshot. I need to review what exactly you are trying to do.
Thanks, Vinay
How to do the automatic data transfer form excel to sql sever by interfaces like python or powershell
This is what I was looking for!!!. One question though, will this process work if my file is in SharePoint folder and the file extension is .csv?
Thank you.
@@pthapa55 yeah it will work, welcome✅
@@lastminutecoders thanks for your response however it seems like the file in Share Point folder must be in a table format because it requires us to provide the Table name, I have file coming in email attachment which is in .xlsx format but now I am trying to find the way to save the file in table format, can you please share if this is possible. Thanks
2 questions:
1. What if the excel file that we intend to import has huge rows i.e. 3K - 200K? Do we still use this process? It might end up taking a considerable amount of time to import.
2. How can we import the file name as well so as to distinguish data imported in between dates or times or may be different times in the same day? I use Power Automate to save excel files with the date and time of getting them. Is there any way that I can import the name as well?
This video is great. Can you post similar videos wherein we can use PA to delete, modify in SQL database. Sorry, I am pretty late in your channel, hence asking these silly questions.
Point 1: Yes definitely it will take a lot of time so remember if it is one time process or a process which you want to run monthly or weekly go with this approach.
Point 2: File Name can be easily extracted from file (For this you can contact me at lastminutescode@gmail.com)
Thankyou, Sure in future I will cover more videos on these topics.
No Questions are Silly😁
pls do more videos. thanks for the video
@@vishnupp5944 sure welcome✅
Would anyone know how to do this so that if existing data is added it doesn't do anything, but if that data doesn't exist in the sql, it adds it... I'm making a condition but it's going crazy
thanks!
Hi your video was helpful.
I have a question .What to do in case the table column have not null uniqueidentifier constraint defined on them.
What's the issue with not null unique identifier constraint?
@@lastminutecoders so there is a column named id in the table. Id column has been declared as an uniqueidentifier, so normally when you try to insert data into this table usinng insert command, this column is automatically populated. We don't have to populate. Now when we using the flow, since this column is marked as nkt null, in the sql step we need to enter the record for id column in for each loop. What can be done to get thisfield automatically populated.
Hi Vinay I have data of 10 lakh even though after splitting it by region some regions have data more then 1 lakh can we load more then 1 lakh data from Excel to SQL server using cloud flow ( list rows present in a table limit is 1 lakh) is there any way to increase the pagination limit in list rows present in table ?
Have you tried looping? Even I have never tested this big of a scenario with Power Automate. But If we use loop and keep Get items action inside Loop, (Let's say you have 2.5 Lakh records so loop will run 3 times - First 1lakh items, then next set of 1 lakh items and finally 50k items.
You will need to use filtering based on ID or Index column.
If you are able to resolve this issue with this approach do let me know. I will also do some research on this.
If i have to trigger this flow through powerautomate than what do i have to do
what was the error that came after you solved the date format error
How to know your Regions environment, if East US or what?
I love you
Show me by doing 'Super Thanks' 😁❤️