Answered

I need to add @ mention to Teams from my powerapps form

(0) Share

Report

Posted on by Kumar09

Here is my formula to send a message to teams but my Nominee Name, Nominee Manager & Submitter Manager is not getting a notification message on teams or tag.

////Send Message to Teams/////

MicrosoftTeams.PostMessageToChannelV3(

"c7154dcd-2cb3-4383-b2bd-e45dcd09b205",/// GroupID

"19:dsLOTCD17xGIDSqGQJlCSYFxELx6tHg-NeAUMob3Y881@thread.tacv2",/// ChannelID

{

content: "Nominee Name: " & DataCardValue45.Selected.DisplayName & " " &

"Nominee Manager: " & DataCardValue2.Selected.DisplayName & " " &

"Submitter Manager: " & DataCardValue4.Selected.DisplayName,

contentType: "Html"

}

);

Can someone help make this formula add this function above or show me a better way with the power flow?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

v-yueyun-msft on at

Like (0)

Report

Hi , @Kumar09

If you want to pass the @mention to your Teams channel , you need to pass this :

<at>userid</at> OR <at>useremail</at>

This is my test code and the result is as follows:

MicrosoftTeams.PostMessageToChannelV3("Group ID","Channel ID",

{content : "Nominee Name: <at>User Email / User ID</at> " ,contentType :"Html"})

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
Kumar09 on at

Like (0)

Report

@v-yueyun-msft
Thank you for replying to my request:
So, this is my current code:

MicrosoftTeams.PostMessageToChannelV3(
"c7154dcd-2cb3-4383-b2bd-e45dcd09b205",/// GroupID
"19:dsLOTCD17xGIDSqGQJlCSYFxELx6tHg-NeAUMob3Y881@thread.tacv2",/// ChannelID
{
content: "Nominee Name: " & DataCardValue45.Selected.DisplayName & " " &
"Nominee Manager: " & DataCardValue2.Selected.DisplayName & " " &
"Submitter Manager: " & DataCardValue4.Selected.DisplayName,
contentType: "Html"
}
);

How would I add this part (<at>userid</at> OR <at>useremail</at>) without removing anything above from my code?

Also, my Nominee Name, Nominee Manager, and Submitter Manager will change everything. Someone in my company uses the spot award app, so will the <at>userid</at> OR <at>useremail</at> work?

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report

Hi , @Kumar09

Thanks for your response! Dose your DataCardValue Control - items property contains the user email in your side?

If this , you can directly try to use this code:

MicrosoftTeams.PostMessageToChannelV3(
"c7154dcd-2cb3-4383-b2bd-e45dcd09b205",/// GroupID
"19:dsLOTCD17xGIDSqGQJlCSYFxELx6tHg-NeAUMob3Y881@thread.tacv2",/// ChannelID
{
content: "Nominee Name: <at>" & DataCardValue45.Selected.Email & "</at> " &
"Nominee Manager: <at>" & DataCardValue2.Selected.Email & "</at> " &
"Submitter Manager: <at>" & DataCardValue4.Selected.Email & "</at>",
contentType: "Html"
}
);

If you don't have an email in your items property, you'll need to add the corresponding email to your data source. Because of DisplayName alone, the backend can't identify who this person really is.

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
Kumar09 on at

Like (0)

Report

@v-yueyun-msft
Oh, okay, so where do I put my exact information about the email? Can you provide a step-by-step process?

Was this reply helpful? Yes No
Kumar09 on at

Like (0)

Report

This process exactly:

If you don't have an email in your items property, you'll need to add the corresponding email to your data source. Because of DisplayName alone, the backend can't identify who this person really is.

How do I make that happen on my side?

Can you please help @v-yueyun-msft

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft on at

Like (0)

Report

Hi , @Kumar09

Thanks for your response!

I mean, you need to get the email or id of this user. For example, we can use the Person type column of SharePoint to get the corresponding email.

If your data source only saves the user's DisplayName, then you need to get the user's email through DisplayName.

For example, you can use Office 365User connector to search the user's email.

First( Office365Users.SearchUserV2({searchTerm:"Your DisplayName" , isSearchTermRequired:true } ).value ).Mail

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No