SharePoint referring to other column values

Question

Hi Everyone,

Below is the JSON code. I was trying to get the document file name in my email body. But it seems it doesn't work. Is there a way to get the document file name ?

JSON CODE

{
"$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
"elmType": "div",
"children": [
{
"elmType": "span",
"style": {
"padding": "12px"
},
"txtContent": "@currentField.title"
},
{
"elmType": "a",
"attributes": {
"iconName": "Mail",
"class": "sp-field-quickActions",
"href": {
"operator": "+",
"operands": [
"mailto:",
"@currentField.email",
"?subject=Tags Not Applied &body=Hi, \n\nYou have not applied tags for the following file [$Name].\n\nRegards"
]
}
}
}
]
}

Outlook Output

Hi XYZ

You have not applied tags for the following file [$Name].

Regards

Answer 1

Hi @Tanvir, Abdullah (Contractor) ,

You should replace column display name “Name” with internal name “FileLeafRef”.

I modified your code and it worked fine in my end:

{  
    "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",  
    "elmType": "div",  
    "children": [  
        {  
            "elmType": "span",  
            "style": {  
                "padding": "12px"  
            },  
            "txtContent": "@currentField.title"  
        },  
        {  
            "elmType": "a",  
            "attributes": {  
                "iconName": "Mail",  
                "class": "sp-field-quickActions",  
                "href": {  
                    "operator": "+",  
                    "operands": [  
                        "mailto:",  
                        "@currentField.email",  
                        "?subject=Tags Not Applied &body=Hi, \n\nYou have not applied tags for the following file: ",  
                                                        "[$FileLeafRef]",  
                                                        "\n\nRegards"  
                    ]  
                }  
            }  
        }  
    ]  
}  

This is my test result:

I hope this information has been useful, please let me know if you still need assistance.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.