![]() ![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |