Forum Discussion
Planner Comments Notifications Resolved
Just created what i believe is a highly effective method to ensure Planner Comment Notifications work seamlessly. We're all familiar with the challenge of comments getting overlooked, especially when staff members haven't previously engaged with a particular task. My new Power Automate solution addresses this issue by sending emails (or you can switch to Teams if preferred) to everyone assigned to a task whenever a comment is posted. The email includes the comment itself and a link to the corresponding task. To adhere to best practices, I created the automation in my user account but set it up to automatically send from an admin@ account. This step isn't mandatory but is recommended, especially if you anticipate commenting on numerous tasks yourself as the automation "owner".
I've uploaded a brief 20-second video demonstrating the functionality. I'd appreciate likes and comments, and I'm more than willing to share the solution. This automation is part of a larger course/solution package I'm developing. Other upcoming features include automatic assignment of unique project codes (you can catch a glimpse of it in the video), auto-assignment of staff based on labels (for instance, if your yellow label is labeled Marketing, it automatically assigns everyone in marketing when used), and more.
I'm eager to hear your thoughts on the comment notification solution; I believe it's one of the most visually appealing solutions available. If want to access the comment notification just @mention me in the comments below.
Here is the step by step guide on how to do this yourself! No sign up required, simply open up the attached PDF or click the link below. Appreciate feedback
Microsoft Planner Task Comment Notification Flow (Step by Step Guide).
Thanks all,Matt
No More Bad Mondays
- Hi Matthew,
I am following the manual steps and I cannot copy/paste expressions. Can you please provide any feedback how can this be done?
Thank you in advance!- Hi Ikevkhi, I've made this even easier and created the solution. Click the link below and import the zip file into your Power Automate. Then you simply just need to change the Group ID to your relevant Planner Group ID. https://forms.office.com/e/MNnEEtFeur
Dear Matthew,
I really appreciate your approach and would be very interested to know how you have implemented this solution.Thank you
Hi Pino, sorry for the delay in getting back to you. Was taking a break over the holidays.
Here is the step by step guide on how to do this yourself! No sign up required, simply click the link below to open or check out my reply to the original post as i've attached the PDF. Appreciate feedback
Microsoft Planner Task Comment Notification Flow (Step by Step Guide).
I would love to see the automation for how you did this, comments in planner have been one of the biggest pain points without a proper @ system and i havent seen a way to trigger a flow when a comment is entered
Hi John814, sorry for the delay in getting back to you. Was taking a break over the holidays.
Here is the step by step guide on how to do this yourself! No sign up required, simply click the link below to open or check out my reply to the original post as i've attached the PDF. Appreciate feedback
Microsoft Planner Task Comment Notification Flow (Step by Step Guide).
- MatthewJamesDavis please revisit step 29, it will not accept your formula in the expression field.
- I'm having the same problem. I've tried to change the parametres in the expression but I couldn't make it work. When using MatthewJamesDavis expression it says it is not valid, and the expression I'm trying to use: split(split(outputs('Get_a_thread_post')?['body/body/content'],'[https://tasks.office.com/X/Home/Task/')[0],'?Type=Comment')[1] goes through but fails when trying it.
Does somebody know how to make it work?
Thanks in advance.- Hi agustin almeida, I've made this even easier and created the solution. Click the link below and import the zip file into your Power Automate. Then you simply just need to change the Group ID to your relevant Planner Group ID. https://forms.office.com/e/MNnEEtFeur
- Hi hopehousedaniel, I've made this even easier and created the solution. Click the link below and import the zip file into your Power Automate. Then you simply just need to change the Group ID to your relevant Planner Group ID. https://forms.office.com/e/MNnEEtFeur
- I have the same issue with step 29.
Could you provide help to fix this?- Hi Hakeemo, I've made this even easier and created the solution. Click the link below and import the zip file into your Power Automate. Then you simply just need to change the Group ID to your relevant Planner Group ID. https://forms.office.com/e/MNnEEtFeur
- Thanks for everyones feedback on this one! I've made this even easier and created the solution. Click the link below and import the zip file into your Power Automate. Then you simply just need to change the Group ID to your relevant Planner Group ID. https://forms.office.com/e/MNnEEtFeur
MatthewJamesDavis
Hi Matthew. Thank you for taking the time to create this solution. Unfortunately, the ZIP file doesn't upload successfully.
I have also spent time trying to create the flow manually following your PDF but it fails on the Get Task Id.Any Suggestions? Thanks
Sean
- Hi Sean, sorry you've had an issue. I've just done a fresh export, so if you pop over and download again you shouldn't have any issues. if you do, drop me a message at email address removed for privacy reasons and i'll support.
Hey everyone, just had some feedback that some had issues with dependencies within the Planner comment solution. This should now be all sorted and you can grab it at www.nomorebadmondays.com/solutions.
- I have requested the file on the web, but it gives an error when importing it. This is the file:
MicrosoftPlannerCommentNotifications_1_0_0_5.zipJotaelecd I had similar problem with the ZIP file.
I managed to upload it using "Import Solution (Dataverse)" rather than "Import Package (Legacy)"
Hope this helps
Steve
- Matthew that is an awesome way to code around planner sending comments to only task assignees versus all project people. One question I would like to take this one step further and not include all the people assigned to the task, but only those we want to call out (or @ mention). Would a possible way to do this is use @ mentions in the comment and then parse the comment for specific @ mentions looking for certain text such as "@matthew" and if that is found within the comment there would be another table for who the email address is to send to. Another option would to always start the comment with @ mention and then end it with a special character to delineate the end like # such as "@matthew#", not sure how you would handle multiple people. Just seeing if you had any ideas on doing this? Thanks for your feedback!
Matt- Hi Matthew, I've just come up with an @mention solution for you. Posted as a new thread on this community, or simply go to our blog about it for the free Power Automate download. https://www.nomorebadmondays.com/post/mentions-in-microsoft-planner
- Thanks so much for the solution and quick turnaround on this! We will let you know how it goes and any feedback. This would be a game changer for this platform.
Hi Matthew,
Awesome solution, by chance do you have an updated PDF that resolves the issue concerning step 29? I also followed the solutions link you provided but was given a 404 error unfortunately.
Thanks!
