I have a Dynamics 365 entity "Opportunity" in the Sales module, I have enabled its integration with a document library.The name of the library is "Opportunity". Now I have two teams, that access the Opportunity entity in D365. I have created views and assigned permissions for the respective teams in D365 as below:
Team A can see Opportunity View 001
Team B can see Opportunity View 002
Now, the issue is how do I separate the folders in the document library "Opportunity"? I don't want to manually break the inheritance and give permission to the teams, on the Folder Level. I have more than 200 records, and on a daily basis more records and folders are created.
My end goal is that, I don't want Team A to see Team B documents, in the SharePoint Library "Opportunity". Is there any way? script or software that I can test.