Sign up / Sign in
SharePoint troubleshooting

SharePoint on-premises gateway setup and troubleshooting

Validate SharePoint on-premises connectivity through the gateway, including site URL reachability, authentication, SSL, list access, and common migration field issues.

SharePointMedium

Use this guide when

  • SharePoint on-prem connection does not show the site or list
  • Gateway cannot reach a SharePoint URL that works in a browser
  • Generated SharePoint create/update actions need on-prem credentials
  • HTTP versus HTTPS or certificate problems

Prerequisites

  • Gateway machine can reach the SharePoint web application URL over HTTP or HTTPS.
  • The credential used by Power Automate can access the target site, list/library, content type, and required fields.
  • SSL certificates are trusted by the gateway host when using HTTPS.
  • SharePoint connector/gateway setup is permitted by tenant and DLP policies.

Fast checks before you debug

  • Test the SharePoint URL in a browser on the gateway machine, not only on your own laptop.
  • Use the canonical site URL that the connector expects; avoid alternate URLs that redirect unexpectedly.
  • Person, lookup, taxonomy, and content type fields often need post-import validation.
  • If the gateway can reach the site but lists do not load, check permissions and list visibility.

Step-by-step diagnostics

Confirm URL reachability from the gateway host

Run tests from the gateway machine. For HTTPS, certificate trust matters. For HTTP, confirm your connector and gateway policy permit the traffic.

Test-NetConnection <sharepoint-hostname> -Port 443
Test-NetConnection <sharepoint-hostname> -Port 80
Invoke-WebRequest https://<sharepoint-hostname>/sites/<site> -UseDefaultCredentials
Validate credentials and site permissions

Sign in or access the site from the gateway machine using the same identity or credential family that the Power Automate connection will use. Confirm the account can open the list/library and read required metadata.

Check list/library and content type behavior

For Flow Migrator create-item or content-type mappings, confirm the target list, content type ID, required fields, lookup fields, and person fields before running the generated flow.

Test a minimal flow connection before importing a complex package

Create a temporary instant flow with a single SharePoint get lists or get item action using the same connection. If the minimal action fails, fix the connection before importing generated workflows.

Common errors and fixes

Gateway connection cannot find the SharePoint site.
Likely cause
The URL is not reachable from the gateway machine, redirects differently, or is blocked by firewall/proxy.
Fix
Test the URL on the gateway host, use the canonical site URL, and verify firewall/proxy/certificate configuration.
Lists load but item actions fail.
Likely cause
Required fields, content types, lookup/person columns, or list permissions differ from the source workflow assumptions.
Fix
Validate field mappings and required fields after import, especially content type and lookup/person fields.
HTTPS SharePoint URL fails only through gateway.
Likely cause
The gateway host does not trust the SharePoint certificate chain or proxy inspection certificate.
Fix
Install trusted root/intermediate certificates on the gateway host and retest from the gateway machine.

Power Automate connection fields

FieldUse this value
Site AddressCanonical SharePoint on-prem site URL reachable from the gateway host.
List / LibraryTarget list or library name, selected after the connection can read metadata.
GatewayGateway host that can reach the SharePoint web application.

Validation checklist

  • Gateway host can open the SharePoint site URL without unexpected redirects or certificate warnings.
  • Power Automate connection can list or read the target list/library.
  • The migration account can create/update items if generated actions need write access.
  • Content type and required field behavior is confirmed for create-item mappings.
  • Generated SharePoint actions bind to the intended site and list during import or required settings review.

Related gateway guides

MySQLTroubleshoot MySQL connection tests, server name resolution, Connector/NET driver issues, user host grants, SSL/encryption errors, and primary key behavior.PostgreSQLCheck PostgreSQL host reachability, Npgsql/provider prerequisites, database grants, schema access, SSL settings, and table primary keys before building PostgreSQL action templates.File SystemTroubleshoot local and network file paths, gateway service account access, UNC paths, mapped drives, permissions, and file-system connector connection tests.