web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Unanswered

Document Management for Dynamics 365 - SharePoint Access Control based on Business Process Flow Stage

(0) ShareShare
ReportReport
Posted on by 20

Hi All,

We are using Dynamics 365 online in Gov Cloud. We have an Entity with a Business Process Flow that has multiple stages. Each stage is owned by a team (Owner Team) and there are use cases when 2 or more different stages are owned by the same team. For Example,  Stage 1 is owned by Team A, Stage 2 is owned by Team B, Stage 3 is Owned by Team A and so on. All our users have a Team Member license and are part of a single team.  We use SharePoint Online for Document Management and Versioning. Each Dynamics record has one or more word documents in its SharePoint location, our requirement is when a record is in Stage 1, only Team A should be able to access the document (from Dynamics 365 document grid, directly through SharePoint URL, MS word Application or by any other means). 

We are planning to achieve this functionality by dynamically controlling the SharePoint Security, that is, break the security inheritance from the site level and provide the access to users (dynamically) at the folder level based on the Dynamics 365 record stage. But we are facing lots of challenges, here are our questions:

  1. Can we achieve this with a plugin that will trigger on Stage Change and configure the SharePoint Security based on Stage? We are using Dynamics 365 online, we may not be able to use/reference SharePoint dll. Is it possible to merge dlls and try using "clientContext"? Is this a good solution?
  2. Can we try using Microsoft Power Automate(Flow) - CDS Update trigger? Will Flow be able to break SharePoint inheritance? The users who move moves the records to Next stage has only contributor privileges in the SharePoint (not admins) , should I update a field or something with Admin account (during on change of a Stage) and then trigger the flow? The trigger looks like premium, is there any other free trigger I can use? 
  3. Is there a better way to achieve this requirement?

FYI, we don't have Global Admin Privilege/Admin Privileges in our tenant, we are admins of our Dynamics 365 Instances and SharePoint sites. Kindly provide suggestions, any assistance  would be greatly appreciated. Thanks in advance!

I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 137 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 57

#3
Jimmy Passeti Profile Picture

Jimmy Passeti 50 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans