cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot use EXCEL file ID on action Insert Row

Insert row can not be used with file ID. Get rows and other actions work fine.

Also, when EXCEL file is replaced,ID changes and flow don't recognise it anymore. The idea would

be to make ID dynamic , not static.

 

 

flow.png

Status: Under Review

Thank you for the suggestion. What you are asking for is the ability to use an action with dynamic input but without selecting a particular file when you're designing the flow. We will evaluate this feature.

Comments
Level: Powered On

You also can't create a table in an excel file and then add data to that new table.

Super User

So I am thinking on a trigger initiated by a user from a Sharepoint Document Library for a selected file, in my case an Excel file. The next step I would like to achieve is to List rows present in a table, assuming all files stored in the Sharepoint Library are excel files with the same table structures.

 

The scenario is detailed in moredetail here: https://powerusers.microsoft.com/t5/Building-Flows/Excel-Business-problems/m-p/107609

 

According to Microsoft's Flow team response; Microsoft flow support to select a file from the picker in the "Excel (Business)" connector currently, but choosing a dynamic content in the "File" field to select a file is not supported in Microsoft flow "Excel (Business)" connector currently.

 

Although the inputs on both action "List rows present in a table" blocks are apparently the same,the inputs on select a file from the picker is a friendly format of the file identifier,you couldn't choose a dynamic content in the "File" field to select a file.

 

So If I want to choose a dynamic content in the "File" field to select a file, there is no way to achieve it in Microsoft Flow currently.

 

As suggested, I am submitting an idea to Flow Ideas Forum.

Level: Powered On

I would like to second this request. It would be very useful to dynamically assign an excel online file. Currently, I'm writing to a template file which is then copied to a designated folder. This works unless multiple flows are running, and then you run the risk of copying over the template file while another flow is in use. I've designed it to wait until the excel file is not in use, but simply being able to dynamically assign a file would greatly reduce the complexity and increase the flows efficiency.

excel.jpg

Level: Powered On

I currently need this connector too. I'm using OneDrive as a workaround, but it's no ideal.

Level: Power Up

I also need this. Having to select a single workbook rather than dynamically select one really limits the usefulness of this connector.