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
Level: Powered On

@matthews1 @wbeedge  @DanielAmico do you resolve it?

Level: Powered On

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

Level: Power Up

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!!

Level: Powered On

@matthews1 up!

Level: Powered On

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