Trigger a Power Automate flow when requesting access to an App or Dataset

The current way of requesting access to Apps and Datasets is inconsistent for end users. There is a level of basic customisation available for requesting access to datasets and no customisation options for requesting access to Apps. Enterprise solutions use Security Groups to manage access to various artefacts, whereas the current request process would bypass this.

Instead, we should have the option to trigger a Power Automate flow when a user requests access to Apps and Datasets. The trigger would need to pass the following information to Power Automate:

• ID of requesting user
• ID and Name of the App or Dataset
• ID of the relevant security group

We can then use the information above to generate a workflow with approvals in Power Automate, thus keeping access management to a minimum and retaining the integrity of security groups.

Using Power Automate would also allow further flexibility, for example with Row Level Security (RLS), we can ensure the requesting user is assigned a role rather than just permissions to a dataset.