- Current issue
We currently are using PowerApps Canvas App to connect to SharePoint online lists by using a service account which means this account is an Office 365 account and uses a unique username and password. but our organization just put the security policy there we must use a Service Principle account, for this kind of data connection, due to security concerns.
- Actions we have taken and issues:
We started to add the Principle service account into PowerApps environments as the application user account, but when we add this account as a new connection, a popup screen for login appears, still need username and password or security key. And the account we add does not have an email address, password. We have done some web research, and most of resources posted for setup principal service account is for Power Automate and for Dataverse (like this A Visual Guide To Power Platform Service Principal Setup (matthewdevaney.com). For our scenario, we are not using Dataverse, we want to use SharePoint Online lists as a backend database and PowerApps Canvas App as interface.
Question
- if it can set up the service Principle user application account (No password and email address) for PowerApps Canvas and we can use this principle application user account to connect with SharePoint online lists as the data source. If yes, what are the steps..
Really appreciated all your help, if we cannot figure this out if we can setup an service principle user account for canvas app to SharePoint online connection, we need redesign the solution by using spfx not able to use PowerApps canvas app. Initial we choose Canvas app and SharePoint online just because this is an existing 2013 version of SharePoint application with customized JavaScript and sandbox .NET solution code, it is easy to migrate to SPO online with same data structure, instead of Dataverse. For interface, we choose PowerApps Canvas app, thinking it may be less code development than SPFX solution.
Kathy
