Forum Discussion
MatthewJamesDavis
Jan 09, 2025Iron Contributor
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
- Abdulmlik101Occasional Reader
Does anyone know how to tag someone with a space in their name?
- TimWatson-TopconCopper Contributor
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" } }
- Ruhama_Amouyal-LebovichCopper Contributor
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
- samueljrodriguezCopper Contributor
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]
- dtyler10Copper Contributor
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?
- JL762Copper Contributor
I have the same issue. Any known solutions?
- esearleCopper Contributor
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?
- GSoucCopper Contributor
Hello. I have the same error. Were you able to resolve it?
- SSiegristCopper Contributor
Do you have a video demonstration how your solution works?
- TimWatson-TopconCopper Contributor
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 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?
- rhegwood2Copper Contributor
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
- MatthewJamesDavisIron Contributor
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 :).
- rhegwood2Copper Contributor
I was able to find but I do not see the "import" option you are showing on walkthrough (see below)