cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
skmcken
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.

4 REPLIES 4
v-lin-msft
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.

 

@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.

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

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Kudoed Authors
Users online (1,524)