So I am thinking on a Manual Trigger is a trigger initiated by a user from a Sharepoint Document Library for a selected file, in my case an Excel file. The next step I would like to achieve is to List rows present in a table, assuming all files stored in the Sharepoint Library are excel files with the same table structures.   The scenario is detailed in moredetail here: https://powerusers.microsoft.com/t5/Building-Flows/Excel-Business-problems/m-p/107609   According to Microsoft's Flow team response; Microsoft flow support to select a file from the picker in the "Excel (Business)" connector currently, but c hoosing a dynamic content in the "File" field to select a file is not supported in Microsoft flow " Excel (Business) " connector  currently.   Although  the inputs on both action "List rows present in a table" blocks are apparently the same,the inputs on select a file from the picker is a friendly format of the file identifier,you couldn't choose a dynamic content in the "File" field to select a file.   So If I want to choose a dynamic  content in the "File" field to select a file, there is no way to achieve it in Microsoft Flow currently.   As suggested, I am submitting an idea to Flow Ideas Forum. ... View more

When getting tables from an Excel file that resides in SharePoint, there is a limit of 256 rows that can be fetched. This limits the usability of this function. The corresponding function for use with an OneDrive for Business-hosted file has a limit of 2,048, which is still fairly low (we have many folks with spreadsheets of 8-10,000 rows or more). I'm still not sure I understand why separate sets of actions are available based on where the file is stored.  ... View more

It will be great if you can create a flow that is triggered with updation of a excel sheet and copy that data to another main excel sheets next available row ... View more