// AI-assisted engineering. Human-owned outcomes.
xcesslogic

Building a Secure Client Onboarding Portal with Power Pages, Power Automate and SharePoint

Businesses that onboard clients through email, spreadsheets, and shared folders often struggle to track missing documents, follow-up tasks, approvals, and onboarding status. A secure client onboarding portal can bring these activities into one place, allowing clients to submit information online while staff monitor progress and follow up on outstanding items.

Microsoft Power Platform can support this workflow using Power Pages for the external-facing portal, Dataverse for structured client and onboarding records, Power Automate for process automation, and SharePoint Online for document management where appropriate. The right design depends on how client accounts, permissions, files, integrations, and workflow stages need to be managed.

What should a client onboarding portal do?

A useful portal should solve a defined business workflow, not simply move an existing paper form onto a website. Depending on the organization, the portal may need to let clients:

  • Sign in securely and access their own organization's records.
  • Complete onboarding forms and save or resume work where required.
  • Submit supporting documents.
  • See which steps are complete and which information is still outstanding.
  • Receive confirmations, reminders, and status updates.
  • Respond to requests for additional information.
  • Review relevant instructions, policies, or onboarding resources.

Internal staff need a corresponding workspace to review submissions, request corrections, update statuses, assign tasks, and see which clients require attention. Administrators may also need reporting, audit information, access management, and configuration controls.

Not every project needs every feature in the first release. The most reliable approach is to define the essential workflow first, then separate launch requirements from later enhancements such as performance dashboards, advanced reporting, or integrations with other business systems.

How the onboarding workflow can work

Consider a service business that needs new clients to provide organization details, contact information, signed documents, and supporting files before work can begin.

A typical workflow could be:

  1. 1Client invitation: An authorized staff member creates or invites the client contact.
  2. 2Secure access: The client signs in and sees the onboarding tasks available to their account.
  3. 3Information collection: The client completes required forms and submits supporting documents.
  4. 4Validation: The system checks required fields and records which documents have been submitted. More complex validation may require a workflow or staff review.
  5. 5Confirmation: The client receives a submission confirmation and staff are notified when action is required.
  6. 6Review: Staff check the information and either approve it or request corrections.
  7. 7Follow-up: Automated reminders can be sent when required information remains outstanding, subject to the organization's rules.
  8. 8Completion: The onboarding record is marked complete and the client receives the appropriate update.

The workflow should define what happens when a submission is incomplete, a file is rejected, a reminder fails, or a client has several open onboarding requests. These exceptions are part of the business process, not details to leave until after launch.

Which Microsoft Power Platform components are needed?

The components have different responsibilities. Choosing them based on the workflow avoids building an unnecessarily complicated solution.

Component Typical responsibility Important design question
Power Pages External-facing portal and authenticated client experience What can external users view and submit?
Dataverse Structured records for organizations, contacts, onboarding cases, tasks and statuses Which records relate to each organization, and who can access them?
Power Automate Notifications, reminders, routing, and process orchestration What triggers each action, and how are failures handled?
SharePoint Online Document libraries and document collaboration where appropriate How are files associated with records and protected from unauthorized access?
Power Apps Internal staff interface, review screens, and operational tools What do staff need to review, update, assign, or report?
Power BI or built-in reporting Operational and management reporting when justified Which metrics are useful, and who is authorized to see them?
APIs and connectors Integration with existing business systems Which system owns each data item, and how are errors reconciled?

The exact architecture should be validated against current Microsoft capabilities, licensing, data volumes, security requirements, and the organization's Microsoft environment. A Power Apps internal application is not automatically necessary if existing Dataverse or Power Pages capabilities meet the need. Likewise, a separate reporting platform may be unnecessary for a simple first release.

For a more detailed comparison, see Microsoft Power Pages vs. a custom-built client portal.

Design the data model before building the forms

A portal becomes difficult to maintain when forms, uploaded documents, and status fields are designed independently. Begin by identifying the main business records and their relationships.

A possible starting model includes:

  • Organization: The client company or customer account.
  • Contact: An individual who can access the portal on behalf of an organization.
  • Onboarding case: A specific onboarding process for an organization or contact.
  • Form submission: The information submitted for a particular step.
  • Document record: Metadata about a submitted file, its relationship to the onboarding case, and its review status.
  • Task or requirement: A required action, its owner, due date if applicable, and completion state.
  • Activity or audit information: Relevant status changes and actions that must be traceable.

This is a conceptual model, not a universal schema. A smaller organization may need fewer tables; a regulated or multi-entity workflow may need more. Determine whether one organization can have multiple contacts, whether a contact can belong to multiple organizations, and whether one client can have several simultaneous onboarding cases.

Agree on status definitions before implementation. For example: Draft, Submitted, Under Review, Action Required, Approved, and Complete. Define who can make each transition and whether the client can see the internal status.

How to keep each client's data separate

External-facing portals need explicit authorization design. A successful login only establishes identity; it does not automatically mean the user should be allowed to read or update every record in the environment.

The implementation should define:

  • How contacts are associated with client organizations.
  • Which web roles external users receive.
  • Which Dataverse tables and records each role can access.
  • Whether permissions are scoped to a contact, account, or another relationship.
  • Which fields clients may create or update.
  • Which pages and operations require authentication.
  • How uploaded documents inherit or enforce appropriate access restrictions.
  • How access is revoked when a contact leaves an organization.

Test with multiple sample organizations and multiple contacts. Attempt direct record access, modified record identifiers, unauthorized updates, and document URL access. A test that merely confirms the correct records appear in the normal interface is not sufficient.

Read the dedicated guide: How to give each client secure access to their own records in Power Pages.

Collecting and managing client documents

A document upload should be connected to a defined onboarding task or case. Otherwise, staff may receive a file without knowing which requirement it satisfies, which client submitted it, or whether it has been reviewed.

The design should cover:

  • Permitted file types and size limits.
  • Required versus optional documents.
  • Clear upload instructions and submission confirmation.
  • The relationship between a file and its client, organization, onboarding case, and requirement.
  • Staff review and rejection reasons.
  • Replacement versions and resubmission.
  • Storage, retention, deletion, and access rules.
  • Safe handling of unexpected file types and failed uploads.

SharePoint Online may be appropriate when staff already use Microsoft 365 document libraries and need familiar collaboration or retention capabilities. Dataverse file storage or another supported approach may be appropriate depending on the use case. Choose based on requirements and licensing rather than assuming one storage option is always best.

See how to collect client documents online using Power Pages and SharePoint.

Automate reminders and status updates

Power Automate can reduce manual follow-up, but workflows need explicit trigger conditions and failure handling.

Examples include:

  • Sending a confirmation after a valid submission.
  • Notifying a staff queue when a new onboarding case is ready for review.
  • Sending a reminder when a required document remains outstanding.
  • Notifying a client when a submission needs correction.
  • Informing staff when a case has not progressed within a defined period.
  • Sending a completion message after all required checks pass.

Avoid creating duplicate reminders when a client updates a record several times. Define the timing rules, maximum number of reminders, business-day behavior, time zone, opt-out or communication preferences where applicable, and what happens if an email fails. A notification should not disclose confidential data that the recipient does not need.

See automating client onboarding with Power Automate.

Give clients and staff useful progress visibility

A status indicator should answer a practical question: what has been completed, what remains outstanding, and who needs to act next?

The client view might show a short list of steps with clear labels and outstanding requirements. The staff view may include assigned reviewer, submission date, outstanding items, overdue tasks, and exceptions. Internal notes and sensitive review details should not automatically be exposed to external users.

Define status transitions and completion rules before creating dashboards. A case should not become complete merely because a form was submitted if required documents or approvals are still missing.

See how to track client onboarding progress in Power Apps and Dataverse.

Implementation phases

A staged approach makes scope and acceptance criteria easier to manage.

Phase 1: Discovery and workflow definition

Document user types, organization relationships, forms, documents, approval rules, notifications, integrations, reporting needs, security expectations, and operational exceptions. Confirm what is included in the first release.

Phase 2: Solution design

Agree on the data model, authentication approach, authorization model, document-storage design, portal navigation, status definitions, workflow triggers, and environment/deployment strategy.

Phase 3: Build the essential portal

Implement the sign-in experience, core forms, client-specific access, document submission, staff review process, and essential notifications. Keep optional dashboards and nonessential integrations out of the critical path unless required.

Phase 4: End-to-end testing

Test complete journeys for different client organizations and user roles. Include incomplete forms, rejected documents, repeated submissions, unauthorized access attempts, notification failures, and browser/device compatibility.

Phase 5: Deployment and handoff

Deploy into the agreed company-owned Microsoft environment using a controlled release process. Document configuration, permissions, workflows, integrations, support procedures, known limitations, and administrator responsibilities. Confirm who owns the environments, credentials, data, and ongoing maintenance.

Phase 6: Improvement

Use feedback and operational data to identify the next valuable enhancements. A management dashboard, integration, or additional onboarding workflow should be added because it addresses a defined need - not simply because the platform supports it.

What affects the cost?

The budget depends on more than the number of portal pages. Major drivers include the complexity of client-specific permissions, number of forms and workflow branches, document management, external identity requirements, integrations, reporting, testing, deployment controls, and ongoing support. Microsoft licensing and capacity costs must be assessed separately against the actual design and current licensing terms.

Before estimating, define the minimum viable scope and acceptance criteria. The Microsoft Power Pages client portal cost guide explains the main cost drivers. The client portal requirements checklist can help prepare for discovery.

When might a custom-built portal be more appropriate?

Power Pages can be a good fit when the organization already uses Microsoft 365 and Dataverse, wants to integrate with the Microsoft ecosystem, and can work within the platform's capabilities and licensing model.

A custom-built portal may deserve consideration when the experience requires unusual interaction patterns, highly specialized business logic, non-Microsoft infrastructure, different deployment constraints, or more control over the application architecture. A hybrid approach may also be appropriate.

Compare the options against business requirements, security, total cost of ownership, integration needs, operational skills, and long-term maintenance - not only initial development effort. Read Power Pages vs. a custom-built client portal.

Questions to resolve before starting

Before committing to development, answer these questions:

  1. 1Who will use the portal: client contacts, internal staff, administrators, or third parties?
  2. 2Can one organization have multiple users, and can a user belong to multiple organizations?
  3. 3What information and documents must each client submit?
  4. 4Which fields and documents require internal approval?
  5. 5What status updates can clients see?
  6. 6Which reminders and notifications are needed, and when should they stop?
  7. 7What systems must be integrated?
  8. 8What are the retention, audit, privacy, and access requirements?
  9. 9Which Microsoft environment will own the solution?
  10. 10What must be demonstrated for the project to be accepted?

Use the Microsoft Power Platform client portal requirements checklist to organize the answers.

// RELATED PLAYBOOKS & ARCHITECTURE GUIDES