You’re offline. This is a read only version of the page.
11
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
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
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.
Share
Report
All responses (
Answers (
