This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
You may have a misunderstanding on what the SharePoint List Input tool is designed for. It's used to return records on lists pages, such as one pictured below. While you can probably read in a list that contains the Excel file you're looking for, it won't actually read in the Excel file (or any other file) itself.
Depending on your SharePoint environment (i.e. version, cloud vs on-premise, authentication mechanism) you may be able to use the Download tool to read in your file. You may see if you can open that location in an Explorer window . If you can, you can then just point a normal input tool to that location. Note however... while it looks/behaves like a network share, the location path it opened with may not always be the same so you can't rely that your Workflow will always be able to access that file as you have it configured in the Input tool.
In regards to the URL you should be entering in the tool, it should only be to the page that contains your list libraries. Looking at the fragments of the error you censored out, you entered a URL that is to a specific object, your Excel file presumably, which, as mentioned, is not something that this tool can return.