cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Automatic selection the file with excel

Hello,

 

I'm trying to make a flow that get data rows from excel and put it in another excel, the problem is when upload a new excel file because a need to change de file path in the excel block, I want to the flow change it automatic and I don't know how.

 

Thanks for the help.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dual Super User III
Dual Super User III

Re: Automatic selection the file with excel

Hi again

I think I have good news!

As April Dunnam explains in this same community "John Liu just wrote a blog post with a work-around to dynamically set the spreadsheet file location.  It involves using an HTTP request to get the MS Graph ID of the file.  I totally agree this functionality should be native with the connector but this is a great work-around in the meantime.  http://johnliu.net/blog/2019/5/workarounds-needed-to-use-the-excel-connector-in-microsoft-flow"

Please try with this approach and let us know

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

9 REPLIES 9
Highlighted
Dual Super User III
Dual Super User III

Re: Automatic selection the file with excel

Hi
Just to understand better your requirements Where are you uploading files? One drive for business? Sharepoint? One drive?
And
Which is your flow trigger?


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Dual Super User III
Dual Super User III

Re: Automatic selection the file with excel

Assuming you are uploading in sharepoint/one drive for business, you will be using excel (business) connector
https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/
One of the declared limitations in the official documentation is the following:

The File property expected by the connector's actions should be filled using one of the following options:
-Pick a file from the file picker.
-Use an output from the OneDrive for Business connector's triggers/actions (file's Id or File identifier property depending on which one is present for the particular OneDrive for Business's action or trigger).
-Use an output from the SharePoint connector's triggers/actions (file's Id or Identifier property depending on which one is present for the particular Sharepoint's action or trigger).

If you plan to use a different approach please le us know
Thanx!


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Frequent Visitor

Re: Automatic selection the file with excel

I have the files in a site of sharepoint and the flow will works with a timer.

Highlighted
Frequent Visitor

Re: Automatic selection the file with excel

In that case I could get de files list in sharepoint and use it for the "file" cell in excel blocks?

Highlighted
Dual Super User III
Dual Super User III

Re: Automatic selection the file with excel

Hi
According to Microsoft official doc, it depends on the trigger you are using in your flow
Did you already decide it?
Hope this helps


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Dual Super User III
Dual Super User III

Re: Automatic selection the file with excel

@brayanrm0097 

Sorry I missed your mention 'the flow works with a timer' till now. Recurence trigger? Can you share a screenshot of your current flow definition?

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Frequent Visitor

Re: Automatic selection the file with excel

Hi

The trigger can change, the important is how allow the flow take the path of the new excel file automatically for update rows of the  another file?

Highlighted
Dual Super User III
Dual Super User III

Re: Automatic selection the file with excel

@brayanrm0097 

I think there is a misunderstanding. As I explained before, the Microsoft official doc says, what you are trying to achieve depends on the trigger you use.

If you do not even know the trigger, it is difficult to say. I will try to find a workaround in the meanwhile.

Hope this helps

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Dual Super User III
Dual Super User III

Re: Automatic selection the file with excel

Hi again

I think I have good news!

As April Dunnam explains in this same community "John Liu just wrote a blog post with a work-around to dynamically set the spreadsheet file location.  It involves using an HTTP request to get the MS Graph ID of the file.  I totally agree this functionality should be native with the connector but this is a great work-around in the meantime.  http://johnliu.net/blog/2019/5/workarounds-needed-to-use-the-excel-connector-in-microsoft-flow"

Please try with this approach and let us know

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Top Kudoed Authors
Users online (13,984)