Share
ReportHi all,
New to power automate but this stuffs awesome. Currently attempting a task time tracker by updating an excel file when the trigger planner task completed is activated. I am currently stuck converting the "Planner" "Start Date Time" into my excel file. The issue is when converting the "Start Date Time" the "baseTime" is always [ "baseTime": "2022-05-17T10:00:00Z" ]. Does the "Start Date Time" option in planner not register the actual time it was clicked like "Completed Date Time" does?
Here is the output I receive when running the test. The above time conversion is the conversion of "Start Date Time" which the "baseTime" never changes. The bottom half is the "Completed Date Time"
Here is my entire flow for updating the rows w/ the start time and end times from planner to excel.
my end game is updating excel with the "start date hours and minutes" and the "completed date hours and minute" so i can do a formula in excel for [start date hours - completed date hours = total hours spent on task].
All responses (
Answers (
65
