Share
ReportWhen an iten is created in my sharepoint I want a clock to start
When the manager going into this item and modifies it to approved...i want the clock to stop
someone responded in a previous post with this:
You can then create a Power Automate flow that triggers on "When an item is created or modified" for this list and add a condition step to check whether both the Status is equal to "Approved" AND LapsedResponseTime=null.
If these two conditions are true, you can then do a datediff between the Modified value and the Created value to determine the time that has lapsed betwen them. Lastly, update the item and set the "LapsedResponseTime" value to the result of the datediff.
Makes sense but not sure how to build it. If there is another way feel free to tell me. The time in the picture below is what I need
All responses (
Answers (
10,450
