cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

add a row to a table using parameters

Hi all,

 

I am using the add a row to a table in excel on-line utilizing a parameter to dynamically select the file that I want to update however I am getting this error: The parameter 'file' has an invalid value, when I compare the manually selected file path and what I am providing, they are the exact same. Is it not possible to use a parameter?

1 ACCEPTED SOLUTION

Accepted Solutions

Hey @Anonymous 

 

This is a known issue with the excel connector. You have to select the file through the browse folder action and actually naigate through the folders and select the file. Once the file is selected, you have to select the table from the drop down only. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

7 REPLIES 7
ScottShearer
Super User
Super User

@Anonymous 

Can you post a screen shot of your Flow?  That will make it much easier to assist.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Anonymous
Not applicable

add a row to a table.png

 

They are the same: 

add a row to a table 2.png

 

@ScottShearer 

Hi @Anonymous ,

 

We could only select an Excel file through File Browse in the "Add a row into a table" action in Microsoft flow currently, the dynamic content of File path is not supported in the File field in the "Add a row into a table" action currently.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hey @Anonymous 

 

This is a known issue with the excel connector. You have to select the file through the browse folder action and actually naigate through the folders and select the file. Once the file is selected, you have to select the table from the drop down only. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Anonymous
Not applicable

This is not solved. They just pointed out that the functionality does not exist. Microsoft please re-consider your status and points crediting. This is a terrible user experience. 

Alan_Sanchez
Helper II
Helper II

A fix for this would be magical, Microsoft. How about getting to work and actually solving a problem instead of calling out the obvious? 

Simon_Quarmby
Regular Visitor

I agree... this is 'unbalanced' missing functionality.

 

It is possible to create a file using dynamic data (in a folder created by dynamic data) but, then, it is not possible to access this file.

 

This makes no sense; if a user (like me) wants to create a bespoke file for the workflow, then I should also be able to access it again. In my case, I want to create a file, then add data rows to it.

 

How can this be accelerated in terms of development by Microsoft?

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (3,522)