The Sharepoint Folder connector is way too slow when I have ot read a single file that is stored on Sharepoint.
I don't see why there wouldn't be an "Online Excel File" connector that would render as "Excel.Workbook(Web.Contents())".
Or at least, when using Sharepoint Folder connector and the user ends up selecting a single file, it should be rendered using the Web.Contents connector and get rid of the steps that scans the Sharepoint site for all files.
I endup using Excel.Workbook(Web.Contents()) to speedup the file reading part. Otherwise the query is very slow if the Sharepoint site contains thousands of files.