Answered

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

(0) Share

Report

Posted on by Community Power Pla... 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?

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

Sort by

CFernandes 8,504 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
CFernandes 8,504 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Thanks,
Bhavesh N

Was this reply helpful? Yes No
CFernandes 8,504 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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 -

In Teams you will get

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Verified answer

CFernandes 8,504 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@CFernandes - It worked, thank you!

Thanks,
Bhavesh N

Was this reply helpful? Yes No