Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Microsoft Excel - Get Rows

I am trying to itterate through a collection of Excel Files held within multiple ShrePoint Libraries however, they abaility to dynamically give values to the Table Name are failing. I believe at moment you can also specify a static name after select a file from above. Is this behaviour going to change as, with the inabiity to extract and load rows from multiple files in Data Flows currently, this is a significant show stopper at the moment.

Post Prodigy
Post Prodigy

Hi @skmcken,


Is the dynamic assignment table name you mentioned referring to this? The red line in the screenshot refers to this. It's can't change the table name dynamically.Annotation 2019-06-12 093936.png

Could you share the screenshot of your flow configuration, please? Maybe we can solve your problem in other ways.


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.




So when I built the flow, I built it using a Static Workbook. Once the Flow was confirmed working, I changed the Values from Static to Dynamic based on each workbook within a library.

SP Flow - Dynamic.PNG

Now what I don't get, is that I have a very similar Flow already built and, has been working for months. The only difference being the Workbooks are referenced in OneDrive for Business. At present, I have to copy each Workbook from SharePoint to a OneDrive for Business Location then, do the extract.


OD Flow - Dynamic.PNG


Considering OneDrive for Business is just a Personal SharePoint Site, I can't see why there is a difference in this. I need to export the SharePoint Flow to provide as a solution to others and, making it jump to a Folder on somebody's Personal OneDrive for Business is not an option.


In addtion, the OneDrive Flow is extracting the data to CDS however, I have now been told that my A5 Licence which includes PowerApps does not include the feature of using the Model Entity which, seems to be pointless on the basis that the new Data Flows are all designed to use CDS.

Using the Canavas App is too time consuming for the level of relationships within the data in respect of designing Forms and Views let alone the Layout's of these. I could possibly accept having to use the Canvas App if Data flows had the ability to extract data from more than one Excel Workbook at a time.


MS Flow has so much potential but, the 3rd Party Connectors seem to be the only reliable ones. Microsoft Flow Connectors have features that seem to be removed on a constant basis. There is a Road Map for everything but, I don't see a Road Map for Microsoft Connectors and, when they are updated, the feautres that have either been added or depreciated.

Hi @skmcken,


In Excel connector, you can dynamically set the table name, however, if you select an excel file only through file Browse #list-rows-present-in-a-table.


Can you choose to sync the files directly to one drive for business?Annotation 2019-06-13 184929.png

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.

I could choose to sync the files however, this only helps me. This is has a broader concept of scope whereby there will be a number of different items from SharePoint, Excel, Power BI and Flow provided to other Education Office 365 Tennants.


What I do not want them to do is rely on one User having to sync the workbooks to a personal folder in OneDrive for Business and change the connectors.


I can't understand why the behaviour is different between OneDrive and SharePoint when both the systems are essentially the same.


Does this behaviour present the same in Azure Logic Apps as, this may be another option that I have to utilize.

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (4,590)