I have a new environment, not secured to any group (wide open), and have built a Power Automate flow in it that uses 3 levels of approvals. The flow is triggered by New Item Added in SharePoint list. The first approval level seems to be failing about 5% of the time with the error "XrmApprovalsGeneralPermissionsError". The approvers are pulled from a SharePoint list and the emails are correct. The error shows a GUID that is the object ID of the approver assigned (see full error example below). It's not the ID of the Approvals connection owner. When it fails, I go to the admin center, go to that environment, look up the user and they have the Approvals User role enabled - no other roles but that one. If I resubmit the flow, it works every time. In 3 days I have around 1200 instances of this flow kick off and 95% went thru without an issue. I cannot see any rhyme or reason why it sporadically fails on certain approvers. Nothing has been changed with the roles for anyone, including the flow owner or the Approvals connection owner (which is me). The environment is not secured to any group, all users have the correct license, and each failed run works every time that I resubmit it manually. Any ideas? It's a major pain to have to go in and restart these flows.
Full error: The request failed. Error code: 'XrmApprovalsGeneralPermissionsError'. Error Message: 'Encountered a general permissions error trying to access the Microsoft Dataverse database. This could be caused by modification of the approvals administrator or user roles, or by an incompatible plugin. Detailed message: 'Message: RetrievePrivilegeForUser: The user with id 689cde24-15eb-ec11-bb3d-000d3a36fe56 has not been assigned any roles. They need a role with the prvReadmsdyn_flow_actionapprovalmodel privilege.
Code: 0x80042f09
InnerError: ''.
Hi @Baudelaire,
Try following the steps in this article. It worked for me.
Power Automate Approval Flows Failing? (updated) (linkedin.com)
Hope it helps.
Kind Regards,
Dale
WarrenBelz
146,645
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,997
Most Valuable Professional