An issue with using your own user credentials in a flow that will run unattended is that there are a few complications that can arise. Some examples are as follows:
- What happens if you leave the organization and your user account is removed?
- What happens if your access to the environment is removed?
- You are likely to be an administrator with more privileges than required and thus are a potential security risk.
You should consider creating a service principal to connect to Common Data Service in Power Automate. This has many advantages, but the most significant is that it allows you to tightly define the privileges that the flow can use. You would create a security role specifically for the service principal user to achieve this.
The steps to use a service principal in the Common Data Service connector are as follows:
- Register an app in Azure Active Directory with a client secret.
- Create an application user in Common Data Service using...
