How to Connect SharePoint as a Data Source in Power Apps Code Apps

In modern Microsoft Power Apps Code Apps, data integration is no longer done through drag-and-drop connectors like Canvas Apps. Instead, developers use the Power Apps CLI (PAC CLI) and a generated TypeScript SDK to connect to data sources such as Microsoft SharePoint.

Prerequisites

• You must be connected to the environment using PAC CLI

• Have a Power Apps Code App project created

• Access to a SharePoint site + list

• Proper permissions on the list (Read or Edit)

Step wise Implementation

Step 1 : Prepare your SharePoint list.

• This is my Demo list.

Step 2: Add SharePoint as a Data Source (PAC CLI)

• Inside your Code App project, run this command

pac code add-data-source -a "shared_sharepointonline" -c "shared-sharepointonl-0000000-axxx-4ccxx-8wwee-ffffxxx00xx" -t "Demo" -d "https://tenant.sharepoint.com/sites/PACASite"

• -a adapter type

• -c connection reference (connection ID)

• -t table / list name

• -d data source endpoint (SharePoint site URL)

Step 3: What happens after you add SharePoint

Once added, Code Apps automatically generate:

• Where power folder contains schema of SharePoint list.

• Where models and services are used for shaping list objects and built in methods for CRUD respectively.

Reference: https://learn.microsoft.com/en-us/power-apps/developer/code-apps/how-to/connect-to-data

Conclusion

In this way, we can successfully add SharePoint as a data source to a Power Apps Code App using the pac code add-data-source command