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

Must have feature!

Level: Powered On

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

Level: Powered On

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

Level: Powered On

Must have feature!