SharePoint integration - managing the need to reauthorize folders after the user who originally linked them gets offboarded
I'd love to hear others' experiences with integrating SharePoint at the folder level, and how to address the necessity to re-authorize those folders once the user who originally linked them are deactivated. We can't find an easy way to report on which folders are needing to be re-authorized and it's frankly slammed the brakes on our integration dreams! How can we proactively address this instead of finding out retroactively that authorization has broken for some folders?
The only half-baked solution I've found is to pull a Document report, pull all documents using the SharePoint integration type that are owned by the team member who was offboarded, include the project name and folder name, and then export that report to Excel. From there I remove duplicates so that I have a list of project names where there is at least one Document in a folder using the SharePoint integration, and that document was owned by an offboarded user.
Hopefully this braindump makes sense and would love to know if anyone's found a more viable solution.