Hello fellow data people,
I've been helping social-service non-profits collect and store data for 3 years now. After a large initial search I decided to work with Microsoft tech, accessing Microsoft's CRM though PowerApps. I never considered other Microsoft tech because CRM/PowerApps did everything I needed.
I have a client transitioning away from their current SaaS solution and are being advised to offload some data processes to SharePoint, perhaps shifting everything over eventually. They are large social service agency with thousands of clients and dozens of programs. Services can vary greatly between programs, with some overlapping data (ex. referrals). Their current SaaS is not a fully customizable CRM/relational database.
I've never worked with the tool, but after some googling I get the impression that Sharepoint is not up to task to be a large non-profit's case management system, though being free is a big plus. The main limits I see are the lack of complex data relationships, and relatively inflexible user permissions.
I know there's got to be some Sharepoint experts here. Am I being rightfully pessimistic, or can the right developer make Sharepoint sing?