How do I Output an Excel file to my SharePoint site?
I'm not sure I have an answer to your question. I do have an answer to mine.
I was trying to push up an Excel file to my SharePoint Site that is http and not https.
The format is:
//sharepoint.Your_Company_Name.com/sites/Your_SharePoint_Site_Name/Your_Library_Name/Your_File_Name.xlsx|||Your_Sheet_Name
Note: do not add http: to the front of that path
and if you have a space in your Library Name or other parts of the path then you need to add %20 where the space would be.
Good luck.
Alteryx can write files to sharepoint sites - the trick is getting Alteryx/windows to treat sharepoint as a network drive location instead of a website. You do this by using this convention:
\\sharepoint.yourcompany.com@SSL\DavWWWRoot\sites\yourSiteName\yourLibraryName
The ''@SSL ' is necessary if you are using HTTPS on the site.
Thanks for your answer.
I own the SharePoint site so there shouldn't be an issue there. It not https so I removed @SSL from:
I get: Error creating the file "\\sharepoint[....]Networks": Access is denied. [.....] is me leaving out the full addr. Any idea? Does http need to be in front of \\?
Thanks for any help.
Hi @dataMack @Brad1 @JTCairns @AndrewK @nnickerson
I was able to configure the Sharepoint output path as shared by dataMack.
My question is I am unable to schedule this on a weekly basis, when I push the flow to gallery it does not work. Is there a way to resolve this ?
Also in my company I need to first authenticate the Sharepoint link on Internet explorer for the first time and only then does the flow work.
Any guidance here would be valuable.
Thanks in advance
