Forum Discussion
Accessing SharePoint Files with 3rd Party Software
Hello all, I am building a Startup to provide software solution to construction industry, and would like your input for connecting 3rd party software to Sharepoint for accessing files on SharePoint. ...
Why don't you use Power Query to do that? I assume your client is still going to use Excel for analytics and Power Query will consolidate files from SharePoint folders as part of the base functionality. I see no reason to re-invent the wheel there. If you are building ANY kind of software for a Construction Startup, you're still going to need to allow Export to Excel for analysis and probably Import as well. I work for a very large Energy company and we manage Construction in the billions, we haven't gotten away from Excel and we don't plan to. We DID in the past try other cloud-based solutions from 3rd parties who all said "Oh you have to get out of Excel!!" and they all utterly failed in the long run.