Hi,
Below is the MS flow that I have been working on which spits out the all tasks with Start Date and Completion Date.
The flow is working as per my expectation
I am trying to add a new column to the email output which should calculate the duration between the Outage Start Date and Outage Completion Date columns.
I am stuck as I couldn't find any formula/expression that can calculate the new column for me?
Can someone please guide me and tell how should I calculate the duration between two date columns and if there is anything that I need to modify in the current flow to make it work as I am totally new the MS Flow?
Hi there. Check out this article on Date Math in Power Automate, Moving Targets. It might be enough to get you started in the right direction.
Good luck!
-Ed
If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.
Thanks, @edgonzales for your direction.
I tried my workflow using your direction. Below is the new changed flow.
1. I have initialized the 'Date Created' and 'Date Completed' variables
2. Then based on the value received from the list tasks, I am trying to set the value of variables (Date Created and Date Completion) and calculating the ticks at the same time with the below expression:
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
40 | |
37 | |
34 | |
33 | |
28 |
User | Count |
---|---|
46 | |
36 | |
33 | |
25 | |
23 |