How to Connect to SharePoint Using PnP?

Ensure that your Azure service principal has site-selected access to Microsoft Graph and the specific SharePoint site. This access is crucial for effectively using the service principal with PnP PowerShell.

If your Entra app has a delegated scope and you want to log in interactively, you can use this command: `Connect-PnPOnline -Url "" -clientID -Interactive`. Check your SharePoint site-level permissions if the connection doesn’t return the expected site contents.

You might want to consider switching to the Microsoft Graph API instead of PnP, as the latter has faced issues in the past. The Graph API is versatile, and you can easily reuse your code—just change the SiteID and ListID when necessary. It's a very efficient option!

Once you have registered the app, connecting is pretty straightforward. Use: `Connect-PnPOnline -Url "https://yourtenant.sharepoint.com" -Interactive -ClientId "your-client-id"`. Don’t forget to set `http://localhost` as a redirect URI and assign the right delegated API permissions to SharePoint, like `Sites.Read.All`. If you're looking for unattended automation, consider using certificate-based authentication instead of client secrets. For a detailed guide, check out this blog: [In-Depth Guide](https://o365reports.com/register-an-entra-id-application-to-use-with-pnp-powershell/).

Check out the PnP GitHub page; it has comprehensive guides for what you need. You can find details on how to register your application and authenticate it with PnP PowerShell. Here are some useful links: [Registering an Application](https://pnp.github.io/powershell/articles/registerapplication.html) and [Authentication Process](https://pnp.github.io/powershell/articles/authentication.html).