Answered

Get Table - File Input

(0) Share

Report

Posted on by Used_Up_Hipster

I am building a flow to copy data from a table in Excel to a sharepoint list. I can't get any of the connectors to work with the selected file. I understand that dynamic content dosent work with the excel connector but is it possible to accomplish this through a variable made up of the file path and name?

Categories:

Using connectors

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Brad_Groux 4,556 on at

Like
a
(0)

Report
Copy link

Link copied!
@Used_Up_Hipster wrote:
I am building a flow to copy data from a table in Excel to a sharepoint list. I can't get any of the connectors to work with the selected file. I understand that dynamic content dosent work with the excel connector but is it possible to accomplish this through a variable made up of the file path and name?
Could you elaborate on how you aren't able to get teh connectors to work with the file? Can you provide a detailed screenshot of your Flow, and/or any error messages you receive when trying to run the Flow so that we may better support you? I use an Excel table to SharePoint list Flows frequently without issue.
Also, what do you mean in regards to dynamic content not working with th excel connector? Creating variables within Flow is possible, and a key compenent of the service. See the Build more advanced flows than ever blog post, and the follow documentation for details:
Use data operations with Microsoft Flow
Use expressions in conditions to check multiple values
Add a condition to a flow
Apply to Each
A Visual Explanation of Flow Logical Expressions
You may also want to take the time to work through the free Microsoft Flow training provided by Microsoft to get a better understanding of it's capabilities:
Get started with Microsoft Flow
Build more complex flows with Microsoft Flow
Automate a business process using Microsoft Flow
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!

Was this reply helpful? Yes No
Used_Up_Hipster 8 on at

Like
a
(0)

Report
Copy link

Link copied!

@Brad_Groux
I have tried 3 diffrent inputs an I am getting 404 or 400 errors for all of them.

Was this reply helpful? Yes No
Brad_Groux 4,556 on at

Like
a
(0)

Report
Copy link

Link copied!

@Used_Up_Hipster wrote:
@Brad_Groux
I have tried 3 diffrent inputs an I am getting 404 or 400 errors for all of them.
The File input is expecting a formatted file name and extension as the input, such as YourFileName.xlsx. None of the parameters you've tried provide that, you'd want the Filename with extension parameter (string). Before that you could also parse in the Folder path parameter (string) if needed as well.
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!

Was this reply helpful? Yes No
Used_Up_Hipster 8 on at

Like
a
(0)

Report
Copy link

Link copied!
@Brad_Groux

I tried that and it did not work. the attampts that I have made are listed below:
'File Name with Extension' - returns a 400 error with the message "The parameter 'file' has an invalid value 'CT & Cap Analysis [eqip] (x.x.xx) - WIP.xlsm'.". This is the correct file name.
'Folder Parth''File Name with Extension' - returns a 400 error with the message "The parameter 'file' has an invalid value 'Shared Documents/Customer Quotes/2019/XTest_298 - Room101/CT & Cap Analysis [eqip] (x.x.xx) - WIP.xlsm'.". THis is the correct folder and file name.

Was this reply helpful? Yes No
Verified answer

Brad_Groux 4,556 on at

Like
a
(0)

Report
Copy link

Link copied!
@Used_Up_Hipster wrote:
@Brad_Groux

I tried that and it did not work. the attampts that I have made are listed below:
'File Name with Extension' - returns a 400 error with the message "The parameter 'file' has an invalid value 'CT & Cap Analysis [eqip] (x.x.xx) - WIP.xlsm'.". This is the correct file name.
'Folder Parth''File Name with Extension' - returns a 400 error with the message "The parameter 'file' has an invalid value 'Shared Documents/Customer Quotes/2019/XTest_298 - Room101/CT & Cap Analysis [eqip] (x.x.xx) - WIP.xlsm'.". THis is the correct folder and file name.
The issue is that Microsoft Flow Excel Connectors don't currently support macro-enabled Excel files because of it's strict limitations, there are no macro related definitions.
If this is functionality you would like to see added to Flow or a Flow Template, please consider submitting it to the Flow Ideas page, where it can be voted on by other users, and tracked and commented on by the Flow team.
There are currently a few related ideas:
Enable actions on macro-enabled files
Excel - New action - Run a macro
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!

Was this reply helpful? Yes No
Used_Up_Hipster 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Bummer. The file is Macro emabled to allow up to import data fom a sales checklist.

Thanks.

Was this reply helpful? Yes No