web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to @mention User i...
Power Automate
Answered

How to @mention User in "Post a Message" using email ID from Excel retrieved by "Get a Row"

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I am using "Get a Row" to retrieve Dates and corresponding Email IDs from the Row and use them to "Post a Message" in Teams group chat.

 

How can I use the email ID to convert it into a "@mention" to further alert the user?

 

Bhavesh5_0-1686026193712.png

 

Categories:
I have the same question (0)
  • CFernandes Profile Picture
    8,504 Most Valuable Professional on at

    Hey @Anonymous 

     

    Have a look at the blog - https://d365demystified.com/2021/03/17/tag-a-user-in-a-microsoft-teams-post-made-using-power-automate/ 

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

     

    P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @CFernandes ,

     

    The article mentions only the specified users in the token than can be mentioned in the Message. M

     

    My requirement varies as the User varies for each row and only the email ID can from each row can specify which User needs to be mentioned.

     

    Thanks,

    Bhavesh N 

  • CFernandes Profile Picture
    8,504 Most Valuable Professional on at

    @Anonymous Whats the output of the Excel "Ops Call"?

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @CFernandes - Ops call is a column with email IDs in this format - "XYZ.XYZ@Test.com"

     

    Bhavesh5_1-1686031929621.png

     

    Thanks,

    Bhavesh N 

  • CFernandes Profile Picture
    8,504 Most Valuable Professional on at

    @Anonymous 

     

    So If I understand correctly you want to mention the user in teams? Or did I get it wrong?

     

    If you want to mention then follow the below - 

    CFernandes_0-1686033461652.png

     

    In Teams you will get 

     

    CFernandes_1-1686033498354.png

     

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

     

    P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @CFernandes  - Yes, that is correct. I want to Tag the User in MS Team group chat.

     

    I have the Users Email IDs in the Excel which needs to be used as the Source. 

     

    Thanks,

    Bhavesh N 

  • Verified answer
    CFernandes Profile Picture
    8,504 Most Valuable Professional on at

    @Anonymous Pass the Email ID in the action...

     

    CFernandes_0-1686038962860.png

     

    I have hardcoded it but you can pass"Ops Call" as it returns the emails address

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

     

    P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

     

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @CFernandes - It worked, thank you!

     

    Bhavesh5_0-1686039660908.png

     

    Thanks,

    Bhavesh N 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 1,027

#2
Valantis Profile Picture

Valantis 809

#3
Haque Profile Picture

Haque 645

Last 30 days Overall leaderboard