You’re offline. This is a read only version of the page.
25
Hi Everyone ,
I have scenario where in there are three stages of approval
I want to know one request took how many hours in each stage ?
For example
A request is raised by a person it goes to manager that is stage 1 ...and then if manager approves it goes reviewer 1 that is stage 2 and once reviewer approves it goes to stage 3 that is approver and once he approves it will be termed approved
Here the request can go to and fro from stage 3 to stage 2 and like wise stage 2 to stage 1
In this sense for every request i have status column on change it gets updated state
I want to know how much time it toook in stage and if it comes back stage 2 to stage 1 again the time has to be appended or some other approach
I tried keeping transaction table which stores the all the transaction when status changes and then based on key it sums up ...
But no luck if any one can guide me or help here will be appreciated thanks looking forward some one cam reply on to this
Hi @Muzammil_0695 ,
Broad question, so I will outline a model for you- the easiest is to keep a date/time field for when each stage is completed. You may also want to keep a "time taken" field for each stage and calculate this as part of writing to each field.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
Share
Report
All responses (
Answers (
