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


Report
All responses (
Answers (