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
MatthewJamesDavis I appreciate the work that must have gone into this, but it seems like cloud updates have changed the URL structure and what I have is completely different to what you have.
I have tried to upload the file but it errors each time.
Could we maybe get this as a native feature in planner?
This seams like such basic functionality present in many other Microsoft products to have it omitted.
My flow fails everytime at the last condition. So nothing posts.
Does anyone know how to tag someone with a space in their name?
The workflow also allows to tag with the surname if the first name has a space. If that helps.
I'm still trying to get this to work. I've been able to resolve all the errors along the way, but now am left with a "Bad Request" error for the last function "Post Card in Chat or Channel" I'm not able to find out what is wrong. Here is the output:
{ "error": { "code": 400, "message": "Card body contains invalid json characters(s): Message After parsing a value an unexpected character was encountered: :. Path 'body[1].text', line 40, position 29.", "source": "flow-apim-msmanaged-na-eastus2-01.azure-apim.net", "path": "choose[14]\\when[1]\\choose\\otherwise", "policyId": "", "clientRequestId": "a848ea29-eff6-4abf-8ede-ac5ab42ecd06", "dreeSet": "true" } }Thanks for sharing the solution MatthewJamesDavis.
When I ran the flow, it failed indicating the action 'get a task' failed. Then, I checked the split expression and changed the end of my organization Planner URL, but again I got the same result. How can I fix this?
split(split(substring(body('Html_to_text'),lastIndexOf(body('Html_to_text'),'.planner/mytasks?')),'?')[0],'.planner/mytasks?')[1]
Thanks,
Ruhama
The get a task formula needed to be changed on my end. It didn't like the tasks or the "?" question mark in the expression. It's working as expected now. I've copied a version of what I had to change.
split(split(substring(body('Html_to_text'),lastIndexOf(body('Html_to_text'),'%2FHome%2FTask%2F')),'%3F')[0],'%2FHome%2FTask%2F')[1]
I am getting an error either method I use. When I add just lastIndexOf(body('Html_to_text'),'/Home/Task/') or lastIndexOf(body('Html_to_text'),'%2FHome%2FTask%2F') into a variable, the variable comes back with a -1. So I looked at the value of body('Html_to_text') and I could not find any value in there called /Home/Task/ so that is why I am getting a -1 value. Where in the email was the HTML to Text step supposed to add a "/Home/Task/" to the values?
I do not have a connection present for "related resources." I've attempted to follow the instructions for creating a new connection and by searching the connection type, but nothing matches the resource type name. See attached. What am I supposed to select?
I have the same issue. Any known solutions?
I was able to go through all the steps and upload. I then got this error message. import conflicts
You'll need to resolve these conflicts before importing the package
ResourceNMBM Planner Comment @mention Notification V7.1
Import setupCreate as new
Error
Flow save failed with code 'DynamicOperationRequestClientFailure' and message 'The dynamic operation request to API 'teams' operation 'GetUnifiedActionSchema' failed with status code 'Unauthorized'. This may indicate invalid input parameters. Error response: { "error": { "code": "AuthorizationFailed", "message": "A client certificate or authorization header was not provided." } }'.
how do I fix this?
Hello. I have the same error. Were you able to resolve it?
Do you have a video demonstration how your solution works?
