cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lkaspar
Resolver I
Resolver I

Managing Modern Approvals in CDS / Dataverse

Hi All,

 

We are using modern approvals for a lot of different processes. Most approvals have been broken down into 2 flows; the first flow commences when an item is submitted for approval, it kicks off the approval, notifies the approver and terminates. The second flow kicks in when the approver responds. This is working well; we can have long-running approvals and we can do neat thing like cancelling or re-assigning approvals easily.

 

At the end of my first flow, I tag the CDS approval record with all the approval metadata in the Name field, like so:

 
 

image.png

 

The second flow, the response one, uses trigger conditions to only fire when I want it to

image.png

 

 

In my actions I use split() to retrieve information like the company:

 

split(triggerOutputs()?['body/msdyn_flow_approval_name'], '|')[1]

 

 

This works but it's ugly. The more processes utilising Power Automate and the more complex the logic becomes, the harder it will be to manage approvals by parsing strings.

 

Naturally, I would like to just add columns to the approval table and store my information in there. That way I would have a Process choice (or even lookup) column and then I can filter on that. However, Microsoft does not let you add columns to Managed tables. 

 

I am thinking of creating a custom Approval table which has a 1:1 relationship with the Approval table. In there I can just add whatever columns I want.

 

Before I embark on that journey I wanted to hear from the community. I am very interested to hear how other people have tackled this issue.

 

Lukas

 

1 REPLY 1
lkaspar
Resolver I
Resolver I

Bump

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (2,277)