Connecting Power Pages to SharePoint Lists or Tables is an effective means of utilizing online SharePoint data in a Microsoft Power Pages site to enhance online collaboration and data availability and share it without duplicating your data. Below is a detailed step-by-step of what it takes to connect Power Pages to SharePoint Lists:
SharePoint Integration with Power Pages
Power Pages connects to SharePoint Lists by creating virtual tables within Power Pages’ Data workspace. The virtual tables operate like native Dataverse tables; however, they are not a Dataverse table but instead represent your SharePoint list data. In turn, Power Pages will create web pages to view, edit and interact with your SharePoint data as a part of your Power Pages site.
Step-by-Step Guide to Connect Power Pages to SharePoint Lists
1. Access Power Pages Studio
- Go to the Power Pages maker portal at make.powerpages.microsoft.com.
- Open or create the site where you want to integrate the SharePoint data.
2. Add a New Table from External Data
- Click the Table button.
- In the dropdown, select New table from external data.
3. Select Connection Type
- In the wizard, choose your connection.
- Select SharePoint as the external source.
- Click Next.
4. Enter or Select SharePoint Site
- You can either enter the SharePoint URL manually or select one from the recent sites list.
- Click on your desired SharePoint site (e.g., “Power Pages Team”).
5. Choose a SharePoint List
- Once connected to the site, select the SharePoint list you want to use from the available lists.
- For example, select List of courses.
- Ensure the box Configure table and column names that will be used in Dataverse is checked.
- Click Next to proceed.
6. Complete the Data Import and Review
- After selection, review the mapping of table and column names.
- Finish the setup as guided by the wizard.
- Your SharePoint list will now appear as a table in Power Pages (via Dataverse).
7. Configure Table Details
- On the “Configuration” screen, update the table name and column details:
- Display name: (e.g., List of courses)
- Plural name: (e.g., List of courses)
- Schema name: (system-generated, you can adjust if needed)
- Primary key: Usually the SharePoint List ID.
- Primary field: Choose the column, e.g., Title.
You’ll also see a mapping of external columns (from SharePoint) to Dataverse columns. Verify or adjust the Display names and Schema names if needed.
- Click Next when finished.
8. Review and Finish
- On the “Review and finish” screen:
- Confirm all details about your connection.
- You’ll see:
- The external data source (SharePoint)
- The SharePoint site and selected list
- The resulting Dataverse table details (display name, schema name, columns, etc.)
- Ensure all information matches your requirements.
- Click Finish to complete the process.
9. Table Available in Power Pages
- After clicking Finish:
- The SharePoint List table is added to your Power Pages site’s data workspace.
- You can see it listed in the Data tab (e.g., “List of courses”).
Additional Tips
- Virtual tables come with bi-directional synchronization by default: any changes you make from Power Pages will update or adjust the SharePoint list and vice versa.
- Consider enabling Dataverse in your environment as Power Pages’ integrations with external data sources like SharePoint rely on Dataverse to manage those connections.
- If your scenario is limited to uploading or managing documents only and does not require full data synchronization, you may want to utilize Power Automate flows from Power Pages to transfer documents to SharePoint Document Management Libraries.
- For complete document management in Power Pages, you should enable server-based SharePoint integration in the Power Platform Admin Center, configure the document management settings on the Dataverse tables, and appropriately grant permissions.
Benefits of Connecting Power Pages to SharePoint Lists
- Uses the existing SharePoint infrastructure with no data duplication.
- Allows users to engage with SharePoint data with accessible web pages.
- Provides the same management of data with real-time synchronization.
- Improved security and access control with Power Pages permissions.
- Rich forms and user experiences with the Power Pages interface.
By using these steps and considerations, organizations can easily bring SharePoint Lists into Power Pages sites to ensure improved productivity and more effective workflows.
Final Thoughts
Connecting SharePoint Lists with Power Pages provides a direct, low-code website development interface for building collaborative, data-driven portals connected to your MS 365 ecosystem. In addition to breaking down data silos, this also enhances productivity, data integrity, and user engagement across your organization.
At Peafowl IT Solution, we provide end-to-end Power Pages and SharePoint development services, from virtual table integrations to branded, secure, and optimized porting applications. Whether you require a connected business site, custom intranet or workflow automation, we ensure your M365 tools work together to provide an integrated and productive virtual workplace.
