(It will be at the top of the email)Д¤.3.1 Compose action expression (renamed 'Compose NewLine')В - decodeUriComponent( '%0A' )Д¤.3.2 Compose action (renamed 'Compose Text') - Dynamic Content Body or Body Preview of emailД¤.3.3 Compose action expression (renamed 'Compose Find NewLines') - split(outputs( 'Compose_Text' ),В outputs( 'Compose_NewLine' ))Д¤.3.4 Compose action expression - outputs( 'Compose_Find_NewLines' )Д¤.4 Find 'completed' text in email body to determine if the task has beenВ completedД¤.4.1 Use Text Function - Find Text Position using Dynamic Content BodyД¤.4.2 Use Text Function - Substring using output of Find Text Position in previous step (Text = Body of email, Starting Position = Output of Find Text Position, Length = 9ДҐ. Figure out where the line breaks are in the body of the email to record the hours from the user entered comment in planner. Extract the task name from the subject line of the email by using an expression in the Compose action - last(split(triggerBody()?, 'task' )))Д¤.3. Use the 'Convert Time Zone' action to convert the Received time from UTC to your time zoneД¤.2. After that, you can do some nifty formatting in Power Automate in order to parse the emails sent to the group mailbox:Д¤.1. In MS Flow (now called MS Power Automate?) you will need to use the trigger for 'When a new email arrives in a shared mailbox (V2)'Д¤. You need the correct permissions to the O365 group mailbox. Create an excel file in your Sharepoint site with a table that has specific column headers and give it a name like Task Timekeeping.I created the column headers 'Owner', 'Task', 'Hours', 'Complete', and 'Date'.Дў.

I will give an overview of what I did in hopes this can help someone else with the same problem we faced.ДЎ.

So if you are using the comments section for anything else, this will not work, but otherwise it works flawlessly so far. This is where the we are entering the time - the comments of the task (in decimal hours format - just the number, no words). Planner utilizes the O365 group mailbox (also utilized by Teams, Sharepoint, etc.) and effectively by default sends an email almost anytime a task is edited, but specifically so every time someone in the group adds a comment to a task. We already utilized Planner, so I didn't want to give it up because of the familiarity.

I spent some time on this recently because our team needed to track time on projects.

Trackingtime microsoft teams