Upload Excel to SharePoint and Read its contents

[sasa_dev]

I created the Flow as start at user Upload Excel to SharePoint, then it need to get the data of one of the cells in this excel. I used the Excel (Businese), but is show the error message "The parameter 'file' has an invalid value". Is there a way to solve it? Or need to use other connectors?

[yashag2255 · Accepted solution]

Hi @sasa_dev 

There is a known issue with the excel connector that the file value cannot be provided using a variable of dynamically. It needs to be chosen by clicking the folder icon and pointing to the file. (That is particularly why you are facing the error as ou must be pointing the file name to a variable/ dynamic value from the file action/trigger )

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!

[sasa_dev]

Thanks you for your reply.

Do you know any other connector that can be solved?

[yashag2255]

HI @sasa_dev 

This is a problem with the excel connector itself. So as long as you are using excel fiels this will be a problem.

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!