Set Up the Service Account: Create a service account in your Microsoft 365 tenant. Assign appropriate permissions (e.g., "Contribute" or higher) to the service account for the target SharePoint site and list/library.
Create a Connection to SharePoint Using the Service Account: In the Power Apps studio, go to Data > Add data. Select SharePoint as the data source. When prompted for credentials, log in using the service account credentials. This creates a connection to SharePoint that uses the service account. Use the
Service Account Connection in Your Power App: Ensure all SharePoint actions in your app (e.g., Patch, Collect, SubmitForm) use this service account connection.
Ensure Users Do Not Need SharePoint Permissions: Since the service account handles SharePoint operations, users interacting with the app do not need direct access to SharePoint. Power Apps will use the service account's connection to perform CRUD operations (Create, Read, Update, Delete).
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.