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

[mpelletier]

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.

[Anonymous]

This would be a great addition to this connector !

[DanielAmico]

Must have feature!

[wbeedge]

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

[matthews1]

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

[blitwak]

Must have feature!

[blitwak]

@matthews1 @wbeedge  @DanielAmico do you resolve it?

[matthews1]

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

[blitwak2]

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

[blitwak]

@matthews1 up!

[matthews1]

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