Answered

Power Pipelines Approval: 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.

(1) Share

Report

Posted on by slypdog93

Hi - I use Microsoft's Power Pipelines to deploy code between environments and have setup a Cloud Flow to be triggered on the deployments to a specific environment. When triggered, the Cloud Flow will send a request for approval to a designated reviewer in Microsoft teams. That reviewer has both Approvals User and Approvals Administrator security roles within the Power Automate Pipeline environment.

The Pipeline has worked great for several months with no issues until today. We are receiving this error for new deployments. The error message states the Approvals Administrator role needs to be modified. Has anyone else encountered & resolved this error?

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (1)

Report
Hi @slypdog93 ,

Please try these steps.

Go to Power Platform Admin Center (admin.powerplatform.microsoft.com)

Select Environments

Select the environment in which the error occurs

Select Security Roles > See All

Click the ellipsis (...) next to Approvals Administrator and select Edit

Search for "asyncoperation" (aka "System Job") table (select "Show all tables" if not visible)

Update the read permission to "Organization"

Best Regards,

Wearsky

Was this reply helpful? Yes No
pkochanowski 9 on at

Like (0)

Report

I have the same problem but my flow is not part of any enviroment (in fact - we don't have any envirometns defined) - how can I solve the problem than ?

Regards,
Piotr

Was this reply helpful? Yes No
slypdog93 60 on at

Like (0)

Report

Thank you this worked like a charm!

Was this reply helpful? Yes No
slypdog93 60 on at

Like (0)

Report

Hi - In order to use Power Pipelines you will need defined environments. At a bare minimum you will need at least three environments.

1) An Environment to host the Power Platform Pipeline Application
2) A Development environment where you develop your components and add them to a solution
3) A target Environment to deploy your Power Automate Components as a managed solution

To learn more about setting up Microsoft's Power Automate Pipelines I recommend reviewing their documentation:
https://learn.microsoft.com/en-us/power-platform/alm/set-up-pipelines

As well as reviewing Tomasz Poszytek's videos on YouTube over setting up Power Pipelines. I found his videos helpful for an example of how to integrate a Power Pipeline with a GIT repository (Azure Dev Ops in my case).
https://www.youtube.com/@TomaszPoszytek

Was this reply helpful? Yes No
MossyMula 3 on at

Like (0)

Report

This solution has worked for me with a user who was having an issue with an approvals attachment into a MS Teams chat card 👍
I'm happy. User is happy...
Thanks so much. 😀

Was this reply helpful? Yes No
kpfrancois 2 on at

Like (0)

Report

Same for us. We have been using approvals in the teams client without issues in till recently we can no longer see attachments. We only use basic approvals not workflow approvals . We don't have any environments setup in power platform but this did not stop us using basic approvals in the past.

Was this reply helpful? Yes No