Applies To: SharePoint Online Custom action and NITRO Workflows
Description:
This article describes the steps to insert the link of item fetched from query list action in the mail (send mail action).
Detailed Steps:
- Navigate to the list -> Custom actions -> Edit the required custom action -> Edit the ‘Send Mail’ action -> Click gear icon to navigate to ‘Mail Templates’.
- Edit the required mail template -> Select the required text in the mail template that is to be hyperlinked -> Click ‘Insert hyperlink’ icon -> Insert query list item link as shown below:
![](https://www.crowcanyon.help/wp-content/uploads/2023/11/729_1_1-1024x108.png)
Note:
- Please go to the query list that is selected in Query List action -> Open any item -> Copy display form link from the address bar -> Paste it in notepad -> Remove item ID -> Replace yellow highlighted text with display form link.
- Syntax of query list item ID (text highlighted in green): %%QueryListActionName##[ID|ID]%%
- Please replace green highlighted text as per the syntax above.
![](https://www.crowcanyon.help/wp-content/uploads/2023/11/729_2.png)
- Save the mail template.
Sample Example:
Send mail with link of Category item of the IssueType. Here Category is a lookup column in Issue Type.
Custom Action:
![](https://www.crowcanyon.help/wp-content/uploads/2023/11/729_3.png)
Custom Action: Query list action. Note that type is “Item”, that is, this action will fetch a single item (and not a collection of items).
![](https://www.crowcanyon.help/wp-content/uploads/2023/11/729_4-1024x858.png)
Custom Action2: Send Mail Action
![](https://www.crowcanyon.help/wp-content/uploads/2023/11/729_5-1024x813.png)
Mail Template Configuration:
![](https://www.crowcanyon.help/wp-content/uploads/2023/11/729_6-1024x700.png)
Insert Query List Item Link as shown below:
![](https://www.crowcanyon.help/wp-content/uploads/2023/11/729_7.png)
Insert Query List Item Title Link as shown below:
![](https://www.crowcanyon.help/wp-content/uploads/2023/11/729_8.png)
Sample Output:
![](https://www.crowcanyon.help/wp-content/uploads/2023/11/729_9.png)