Power Automate Approval Flows Failing? (updated)

Power Automate Approval Flows Failing? (updated)

Did your Power Automate flows suddenly starting failing with:


"The request failed. Error code: 'XrmApprovalsGeneralPermissionsError'. Error Message: 'The Approvals operation encountered a known permissions issue. To resolve the issue, modify the "Approvals Administrator" role in the Microsoft Dataverse instance to add read permission to the asyncoperation (localized name "System Job") table."?


Ours did yesterday - right after a load of Microsoft solutions updates appeared in the environment. No idea why (nothing changed on our side) - however following the instructions in the error message (its actually one of the more useful I've seen) seemed to resolve it.

Recording here as I couldn't find this error in Google..


Update


After some further digging it looks like there approvals solution needs updating int he affected environment. Here's some information from the Microsoft support knowledgebase:


Recommended solutions

Problem

When creating an approval, you might encounter a BadGateway, 502, XrmApiServerError, 'Request to XRM API failed', or 'Principal user is missing prvReadAsyncOperation privilege' error.

Solution

Update the "Microsoft Flow Approvals" package to the latest version (2.0.4.7 or later) in the environment (please note that these actions need to be performed by an administrator):

  1. Go to Power Platform Admin Center (admin.powerplatform.microsoft.com)
  2. Select Environments
  3. Select the environment in which the error occurs
  4. Select "Dynamics 365 apps" (under Resources)
  5. Look for the "Microsoft Flow Approvals" solution.  Its status should state "Update available".  Click the "Update available" link for this solution.
  6. Check "I agree to the terms of service" 
  7. Click "Update".

Note: Installing the "Microsoft Flow Approvals" package version 2.0.4.7 (or later) grants the "Approvals Administrator" role the missing privilege in the environment.  If you don't have the option to update the package or you are still seeing the error, you can resolve the issue by granting the "Approvals Administrator" role the missing privilege in the environment as follows (please note that these actions need to be performed by an administrator):

  1. Go to Power Platform Admin Center (admin.powerplatform.microsoft.com
  2. Select Environments 
  3. Select the environment in which the error occurs 
  4. Select Security Roles > See All 
  5. Click the ellipsis (...) next to Approvals Administrator and select Edit 
  6. Search for "asyncoperation" (aka "System Job") table (select "Show all tables" if not visible) 
  7. Update the read permission to "Organization" 

 

In my environment the versions of these solutions was 2.0.4.3

Article content

So you could try that if affected - take a backup first!



Paul Beck

Technology Director @ RADIMAGING | Azure Solution Architect, Power Platform, D365, AI, Low Code and automation expert

9mo
Like
Reply
Paul Beck

Technology Director @ RADIMAGING | Azure Solution Architect, Power Platform, D365, AI, Low Code and automation expert

9mo

This post helped me resolve a similar issue, I got a XrmApprovalsUserRoleNotFound error msg. The error start on a working running flow, and required the person running the Approvals action/flow to be in the 'Approvals User' role. The user was already assigned, the admin re-assigned the user, and the flow started working. The exact same flow was running in QA and Prod, however, only dev was encountering the issue. Here is my write up:  

Like
Reply
Caio Almeida

Power Platform Developer at Nexer Group

1y

thank you! Ireally appreciate it.

Like
Reply
Haaron G.

Success Story Maker for the Digital Workplace

1y

It worked for me in my dev tenant. sorry for those huge companies that need to justify the change first in a governance committee in order to get this issue fix

This resolved my problem. Thank you very much. 😉

To view or add a comment, sign in

More articles by Dr Adrian Colquhoun

Insights from the community

Others also viewed

Explore topics