Forum Discussion
Microsoft Planner @Mention and Comment Notification in Microsoft Teams - NEW VERSION
Hi Planner Community,
Thank you for the overwhelming support for my original post last year on how to @mention someone within the Microsoft Planner community and have a message automatically emailed to them.
I'm excited to share that I've completely redesigned and updated the solution to now support the new Microsoft Teams Planner and remove the issues some users found with setting up the solution.
Additionally, the notification is now an adaptive card within the Microsoft Teams chat to the user you @mentioned in the Microsoft Planner comment.
Screenshot example above shows a comment posted by me in a Microsoft Planner task where I’ve @mentioned David at the end of the message.
Screenshot example above shows the comment posted by me in Planner being automatically sent to David (thanks to the @mention in the comment) on Microsoft Teams. Allowing David to reply in either the traditional Planner or new Teams Planner.
Attached is a zip file containing the Microsoft Power Automate solution, along with a detailed walkthrough to help you set it up.
Enjoy! If you download the solution, all I ask is that you please give this post a thumbs up. Thanks, everyone!
Matthew Davis
No More Bad Monday
22 Replies
First,
Thank you, Thank you, Thank you!!!
This is amazing and saved me so much troubleshooting!
A few questions/problems.
- I still receive the error message for the link directly to the planner on the web. The Reply in Teams Planner works great. Perhaps this is because I don't have admin access for the Tenant?
{ "error": { "code": "NotFound", "message": "TenantId not found", "target": null }}
- In the Trim step I sometimes get an error about negative integers in the old and new version.
trim(substring(body('Html_to_text'),0,lastIndexOf(body('Html_to_text'),'@')))
trim(split(substring(string(body('Get_a_thread_post')['body']), add(indexOf(string(body('Get_a_thread_post')['body']), '@'), 1), indexOf(substring(string(body('Get_a_thread_post')['body']), add(indexOf(string(body('Get_a_thread_post')['body']), '@'), 1)), ' ')), ' ')[0])
- Is it possible to tag multiple people in a comment?
- Is it possible to make the Teams Chat message originate from the person making the comment? Or perhaps the Group? Right now they all come from my account which can be confusing.
I am curious about #4. I Just realized that the mentions work for anyone on the plan but all the messages come from me. can I change this?
To change the sender, I worked with my IT team to use a separate IT admin account to own the automation and send the emails. I created the Automation in my account to test, and then transferred ownership. All the connections will need to be changed to the new owner. Now they originate from a generic address and not me. It was fairly easy.
- I still receive the error message for the link directly to the planner on the web. The Reply in Teams Planner works great. Perhaps this is because I don't have admin access for the Tenant?
I do not see "Power Automate" app but I do see "WorkFlows". Is this the same thing? If so how do I install this solution in this app
Workflows is usually only available within Microsoft Teams, whilst Power Automate should be available alongside other applications like Power Apps, Power Bi etc. Accessible from the top left menu. Please provide screenshots if you have any problem finding it :).
I was able to find but I do not see the "import" option you are showing on walkthrough (see below)
