cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mpelletier
Level: Powered On

Can't set dynamic "file" value for excel "get a row" action

I am trying to use Flow so that when someone updates an excel spreadsheet I can grab a few values from it and update attributes in a SharePoint document library.  My POC worked fine in that I can create a spreadsheet, define a "table", and store it in a SharePoint library.  When the file changes, the flow kicks off.  I can use the Excel (Business) connector to connect to my site, library and file, specify the table, key column and key value.  This all works great.  I am able to grab the value and using an update action, update my sharepoint library.

 

The problem is that I want the user to be able to create new spreadsheets, based off a template, that allow them to save new files to the library and have the flow get kicked off.  This would mean that I need to be able to have the "file" attribute of the action be dynamic.  Specifically, it should point to the file that initiated the flow in the first place.  This attribute does not appear to be able to be dynamic.  If I select the file with the picker it works fine.  If I try to use a dynamic property or value I type in through the expression editor it either complains or, if it takes it, tells me it can't find anything. 

 

Am I missing something?  This would be perfect if the file value could be dynamically set rather than statically chosen at design time.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Can't set dynamic "file" value for excel "get a row" action

Hi @ mpelletier,

 

Could you please share a screenshot of the configuration of your flow?

Do you want to choose a dyamnic content in the "File" field to choose a excel file in the "get a row" action of excel online(Business) connector?

Microsoft flow could support to choose the file with the picker currently,

Choosing a dyamnic content in the "File" field to choose a excel file in excel online(Business) connector is not supported in Microsoft flow currently,

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Regards,
Alice Zhang

5 REPLIES 5
Community Support Team
Community Support Team

Re: Can't set dynamic "file" value for excel "get a row" action

Hi @ mpelletier,

 

Could you please share a screenshot of the configuration of your flow?

Do you want to choose a dyamnic content in the "File" field to choose a excel file in the "get a row" action of excel online(Business) connector?

Microsoft flow could support to choose the file with the picker currently,

Choosing a dyamnic content in the "File" field to choose a excel file in excel online(Business) connector is not supported in Microsoft flow currently,

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Regards,
Alice Zhang

mpelletier
Level: Powered On

Re: Can't set dynamic "file" value for excel "get a row" action

Thank you for your response.  Your understanding of my need is correct.  The file picker works just fine if I want to the selected file to be chosen at design time.  My desire was to make it dynamic so that the file could be selected at runtime.  I will submit this as a feature request. 

 

Thanks,

McP

hjaf
Level: Powered On

Re: Can't set dynamic "file" value for excel "get a row" action

Where is your feature request, I'd back this for sure!

 

 

Any of these functions that have fields that cannot be programmatically changed should be made more obvious in the interface.. I have been barking up so many wrong trees its embarassing Smiley Sad 

Highlighted
hjaf
Level: Powered On

Re: Can't set dynamic "file" value for excel "get a row" action

reply was duplicated during post (edit)

tcorcor1
Level: Powered On

Re: Can't set dynamic "file" value for excel "get a row" action

Hi everyone,

 

Wrestled with this yesterday and found something in another discussion that is a great resolve for this. Please see the below link:

 

http://johnliu.net/blog/2019/5/workarounds-needed-to-use-the-excel-connector-in-microsoft-flow

 

You can grab the MS graph ID via SharePoint online API and pass that into the file attribute.

Helpful resources

Announcements
firstImage

Microsoft Flow Online Conference

Join us for a FULL day of FREE Microsoft Flow Sessions from some of the best minds in the industry!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

thirdImage

New Flow Community Board!

Check out the new Microsoft Flow Community Blog Topic Suggestion board!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 176 members 5,101 guests
Please welcome our newest community members: