How to bypass user permissions for updates via PowerApps

When building a solution using PowerApps, it's important to consider permissions. If you want to allow a user to update a single SharePoint column without giving them edit permissions on the entire item, you can use Power Automate flow. Instead of using Patch() or SubmitForm() in PowerApps, you can call a Power Automate flow that uses a fixed connection, such as a service account. This flow can update the desired column and respond back to PowerApps. To set up the flow to use the service account, go to the flow overview page and edit the "Run only users" section. From there, you can specify the account to be used for the update. With the flow properly configured, you can connect it to a button in PowerApps to trigger the update. By combining PowerApps with a flow, you can bypass user permissions and securely update a single column.

Article 10m Tom Riha

---

Login now to access my digest by 365.Training

Login