cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
satyakanth
Frequent Visitor

Automate data upload from various excel sheets to sql on daily basis

I receive data on daily basis in excel sheet to my email

Created a flow to save the files to SharePoint and one drive.

Is it possible create a flow to pick the latest excel file in the folder (SharePoint/OneDrive) and upload the data present in latest excel sheet to existing sql table.

Also the no of rows of data keeps changing. Is it possible to dynamically select the range of rows to eliminate unwanted text present after the data

Eg: Headers (Column Names) of the data are present in A5 and data starts form A6 and no of rows may vary on daily basis.

 and has some unwanted test present in the sheet  below the data leaving two rows gap from data.

My Excel file name format is  "Name_Date_TransactionCode"

Can someone help me how to create a flow 

 

1 REPLY 1
v-litu-msft
Community Support
Community Support

Hi @satyakanth,

 

The part till to "create a flow to pick the latest excel file in the folder (SharePoint/OneDrive) and upload the data present in the latest excel sheet to the existing SQL table" is possible.

Steps are:

When an Email arrived>>Store attachments into a SharePoint folder>>Get the identifier of the file>>Get tables of the file>>List rows in present table>>Insert these data into SQL

Annotation 2020-05-28 132247.jpg

 

Annotation 2020-05-28 132304.jpg

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,509)