Back to Blog

    SharePoint

    Document approval with SharePoint and Power Automate

    A documented approval process with SharePoint and Power Automate: triggers, responsibilities, error cases, permissions and the licensing check.

    February 11, 20242 min read
    Marcel Haas

    Marcel Haas

    Solution Architect, CEO

    marcel.haas@cnext.ch
    CNEXT SharePoint
    In this article

    SharePoint stores documents and list items; Power Automate can respond to them with a defined flow. A good place to start is a single approval, for example for one document.

    Example: approving a document

    A team saves a new template in a SharePoint library. A flow starts when a new document arrives, identifies the responsible reviewer and waits for their decision. Only then does it set the approval status and report the result. Microsoft documents this pattern with the Set content approval status action.

    Before you build a flow, answer five questions:

    1. 1Trigger: Does the process start with every upload or only for certain file types and metadata?
    2. 2Permissions: Who may see the document before approval, and under which connection does the flow run?
    3. 3Exceptions: What happens after a rejection, during an absence, after repeated edits or when a step fails?
    4. 4Evidence: Where are the decision, comment, version and time recorded in a traceable way?
    5. 5Operations: Who receives failure notifications and maintains the flow when people or libraries change?

    Test in a pilot

    Run one successful, one rejected and one failed case. Use test accounts to check that drafts are really visible only to authorised people. For document approvals, Microsoft's instructions require the correct ETag for the version concerned. A repeated or delayed trigger must not approve the wrong version. SharePoint triggers also do not always run immediately; Microsoft describes possible delays of minutes.

    The SharePoint connector is a standard connector. As soon as other services, premium connectors or special features are added, check the current Power Automate licence rights for the specific flow. Measure handling time and errors in the pilot.

    Sources

    SharePoint
    Teilen:

    AI tools may have supported the creation of this article. CNEXT is responsible for the published content. Product features and prices can change; check the linked primary sources for current details.

    Marcel Haas

    Marcel Haas

    Solution Architect, CEO

    6x Microsoft Applied Skills

    Build an approval process with CNEXT

    Talk to us about piloting a first approval flow with test cases.