cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FrobCol
Regular Visitor

Read/Write Approval Table from PowerApps

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  : 

FrobCol_0-1643624581120.png

 

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. 

 

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
bipinshan
Solution Sage
Solution Sage

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 -

bipinshan_0-1643627798665.png

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!

View solution in original post

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

View solution in original post

2 REPLIES 2
bipinshan
Solution Sage
Solution Sage

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 -

bipinshan_0-1643627798665.png

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!

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

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (3,712)