I need an Azure AD group that can be added to an email subscription and can be added to RLS roles.
We have several Azure AD security groups but it was just brought to my attention that these do not work when added to an email subscription.
We also have several Microsoft 365 groups but as far as I am aware, I cannot add those to RLS roles.
The group needs to be in Azure AD (cloud) so we can use a Power App/flow we have created where users request access and after an approvals request, the user is added to the group automatically. This does not seem to work for on premises AD groups, or so I have been told.
So is there a single group type in the cloud that can handle all of the following?