Forum Discussion
CSV File as data source that is on Sharepoint
Hello - so here's my conondrum and hoping someone can help me out with it! I have two data sources - 1 is a SharePoint Online List - which I'm able to connect to. The other is a CSV File (that is dow...
How I have done this is as follows:
- Get Data: From Web
- Get the file URL in my sharepoint.
- Cut the URL where is the extension of the file I want to link, in this case, .cvs.
https://sharepoint.com/Folderspath/File.csvadditional information then https://sharepoint.com/Folderspath/File.csv
- Paste the URL
- Select the type of logon
- Check the query