cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

How to get data from different excel spreadsheets

I have a library of excel spreadsheets.  Users will select a spreadsheet to populate data in another spreadsheet.  I am using the For a selected file trigger.  I tried using Get a row and List rows present in a table actions.  But both have the same issue, I have to select the exact spreadsheet and table the data is coming from.  I have tried using the filename field from the For a selected file trigger as seen in the image.  I also have to manually enter the table name.  PA will save the workflow, but the run fails because it can't find the table.

 

How do I get data from a spreadsheet when I can't preselect it in the File box?

Thanks!

 

excelworkflow.jpg

1 REPLY 1
Highlighted
Super User III
Super User III

Re: How to get data from different excel spreadsheets

Hello @DTooley

Unfortunately this feature does not exist nativity right now.

The only way to get a excel dynamic file name is to use this work around:
http://johnliu.net/blog/2019/5/workarounds-needed-to-use-the-excel-connector-in-microsoft-flow

Please vote for this feature here:
https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Allow-for-dynamic-quot-file-quot-value-for-...

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others




Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips, tricks, and guides
FlowAltDelete




Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (8,962)