Answered

Automatic selection the file with excel

(0) Share

Report

Posted on by brayanrm0097

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.

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
brayanrm0097 23 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
brayanrm0097 23 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
brayanrm0097 23 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Verified answer

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No