Showing results for 
Search instead for 
Did you mean: 
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?




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:

Please vote for this feature here:

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

Helpful resources


Super User Program Update

Three Super User rank tiers have been launched!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021


New & Improved Power Automate Community Cookbook

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


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)