cancel
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
Comments
Anonymous
Not applicable
This would be a great addition to this connector !
Advocate IV

Must have feature!

Frequent Visitor

I have investigated the connector and it can be achieved.
When you initiate the flow you must have an existing file so you can 
set or retrieve all the values you want. Once you have done this you can change the
filename in the connector by using the file ID

Frequent Visitor

@wbeedgecan you elaborate a little? Would love to see a screenshot on how you've done this, I feel like i've tried everything at this point....

Regular Visitor

Must have feature!

Regular Visitor

@matthews1 @wbeedge  @DanielAmico do you resolve it?

Frequent Visitor

@blitwak , not exactly. Ended up working around it by reading a file out of onedrive vs a file in a document library on SP. When reading from OneDrive you can use dynamic names. Makes a whole lot of sense, given OD4B runs on a sharepoint backend....

 

So, to answer, no, but yes.

New Member

Hi @matthews1 !

I dont understand your work around!

Can you please explain it better?

Read file from another source? such as dropbox or drive? and use excel connector?

Thank you very much!!

Regular Visitor

@matthews1 up!

Frequent Visitor

@blitwak @blitwak2 

 

Per the orginal idea post...

 

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

 

It references the read excel "action" in flow from a sharepoint online document library and not being able to use dynamic file name. What I was mentioning as my work around, until this functionality is added, is to actually change our whole flow to write an excel speadsheet with a table to OneDrive for Business, instead of Sharepoint, and the read file action from a OneDrive based file, allows for Dynamic file names.