Showing results for 
Search instead for 
Did you mean: 

Allow for dynamic "file" value for excel "get a row" action

When using the Excel (Business) connector you can currently select the "File" that will be used for the "get row" action at design time.  This works fine if the spreadsheet already exists and you want to continously reference it when you flow is initiated.  However, if you wanted to set up a document library that contained an Excel spreadsheet as a template that a user could edit and save to the library to then have a Flow take action on, you can't.  Specifically, I would like the ability so that either through a manual trigger or when the spreadsheet is new/updated that the spreadsheet file (name, link, whatever is needed) could be used as a dynamic value on the "get row" action so that I could just grab a cell from the newly created spreadsheet and use it in the rest of the flow.




Status: New
Regular Visitor


Which was your work around?


I try unccessfully with SharePoint and OneDrive for Business.

We are using Excel Online connector and File parameter only allows to pick up existing files in SharePoint or OneDrive for Business. We need to create file on the fly (new quote) and bind it to it.


Our workaround that we found yesterday doesn’t work always (copy it to an existing file and work on that) because sometimes it says: The file is currently checked out or locked for editing by another user.




Frequent Visitor



I have the same issue, with the file locking issue. After the file is opened, and read, regardless of SP or OD4B, it remains in a locked state for an hour-ish, I believe, no real way around that. Sorry I can't help much with that. I had to put a wait in my flow, for an hour and 15 minutes before moving the file to a completed folder after it was read.

Regular Visitor

@matthews1 Thanks!!!

Frequent Visitor

@blitwak Sorry I couldn't be of more help. Just getting my feet into the water with Flow right now. Learning as I go! 🙂

Regular Visitor

@matthews1 dont worry! We are in the same! Where are you from? I am from Argentina!


Yesterday we also learned Flow. We are using it with a template that saves my email attachments  to a SharePoint document library!

Frequent Visitor

@blitwak United States here my friend, in effort to not muddy up this thread. Feel free to hit me up on discord or email if you'd like. I'll PM you my info.

Advocate IV

Hi Guys at Flow product team,


Please solve this idea.

Without dynamic file path or if you prefer dynamic file name for excel the actions for the excel connector are too limited.

Imagine this scenario to envision the utility of this idea:


A Company wants to send weekly reports in excel to sales team

  1. You create a blank template excel with a table inside
  2. with a apply to each, generate a file per sales team member
  3. Populate each one with correspondent data
  4. send by email the report to each member.

Nowadays without the  possibility to use dynamic file path in "add rows to a table" the step 3 is not possible.


I'm pretty sure this is a very commom scenario in everyday life of a company, where flow could be a great addition.


Please ear us !!!!!

Advocate V

Still waiting for a dynamicall fiel path for exel online connectors. 


As @moutinhoabreu says, there are scenarios like his one and many other more, where dynamicall file path for the excel online files are needed.


Actually we are working with very, very, very bad work-arround like having a switch in the flow and a own Excel-online-node for every excel file we have and which the flow need a connection for!!! We need dynamical file pathes.


I see no way for a work-arround when you have different excel files with different pathes and different file names but having the same structure and you want to read/edit different of these files with same structure with the same work flow.


It is important!

Frequent Visitor

I have a similiar question...but for OneDrive.
Here's what I'm trying to do:
We have a nightly process that uploads a new excel file at 4:00am every day with a new file name.
1) When a new excel file is uploaded to OneDrive
2) Get a list of rows in the excel file.

Flow error. How do I get the path to the file in OneDrive?

Super User

2 years passed and they added something similar and not good enough.


When you try list a rows you can list newly created file however when you try to update newly created file with path made of "ID" then flow can't find a file. Same connector, same expression, same method, different action, different result.