Microsoft Excel - Get Rows

[skmcken]

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.

[v-lin-msft]

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.

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.

[skmcken]

@v-lin-msft 

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.

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.

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.

[v-lin-msft]

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?

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.

[skmcken]

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.