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