Read/Write Approval Table from PowerApps

[FrobCol]

Hi everyone, this is my first post on this forum.

I am using power apps for 1 year now and often consult this forum. However, I couldn't find any post with a clear answer to this question : 

I use a gallery in Power Apps displaying the content of a SharePoint List. The Powerapps allows any user of my organization to create a new item in this SP List with a customs form. When a new item is created it starts an approval in Teams with MS flow, I update the row in the SP list with the approval ID in a specific field then I wait for an approval response. 

I would like to add a screen to manage Approval in my PowerApps. I believe it is doable with a premium license (which I have) :

I put a button In my apps that call a flow with the approval ID stored in the SP list as a parameter, the flow will "update a record" of the approvals table with the Approval ID but it seems like I don't have the rights to write this table as it returns an error. 

My flow that I call from Power apps looks like this  : 

My question is :

Do you think it is possible to do what I want ? 

Is it ok to update the status of an approval with this method ?

What do i need (license, role etc.) to update a record in approval table ?

PS : I have a premium license of power apps and I am power Admin in my organization. 

[bipinshan · Accepted solution]

Hi @FrobCol ,

You will also need to create Approval Response Entity record against Approval.

In Dataverse we have three entities for Approval which stores the approval data - 

Approval

Approval Request

Approval Response

Also, try to update below fields in Approval entity from your flow -

1. Result  - Approve/Reject

2. Stage - Complete

3. Status - Completed

4. Status Reason - Inactive

Would you be able to share the error details ?

Regards,

Bipin Kumar
Follow my Blog: https://xrmdynamicscrm.wordpress.com/

Kudos and Accept my answer if helpful!

[FrobCol · Accepted solution]

Hi, @bipinshan thanks for the tips about creating an Approval response entity. 

I don't have any error anymore, it looks like I posted my message before my role as a power admin was granted. 

So let me summarize what needs to be done to manage Approval from Power Apps. (The outcome is a complete application to manage holidays requests integrated with Teams' approval management.) :

what is needed :

- Power Automate per user plan.

- Power Admin Role (or read write permission on approvals tables)

- Time (7 days of work if you are not an advanced powerapps user like me) 

If some of you are interested in creating a leave/request app with a calendar view integrated with teams' approval I can try to show you what tutorials I used

[Mrc4t987]

My Status and Status Reason columns are locked from editing despite having the system administrator and Approval Administrator role, do you know why this is the case? is there a way to unlock them?

[Zhanserik]

HI @FrobCol , I am working on the almost same project, could you show me what tutorials you used?