Add users assets into an email

[Alex Saager1]

Hi Community,

We have a flow setup that will email a person's line manager a few days before their leave date and I want to add the leavers assets into the email, can anyone adivse on the best way to achive this as at present we can only get one asset returned.

Here is the flow:

[Dr Atul G- LNG]

@Sandeep Rajput  @SANDEEP DUTTA  @Mark Manders @Ankur Bawiskar  @Shivalika  any help here.

[Mark Manders]

There are 2 ways to handle this. Either do a lookup to the asset table and get the assets of the user and add them to a string variable (update the variable for each found asset) and use the text from the variable in the 'send email' body. Or use the 'send notification' action and do a lookup to all assets within an email notification script and add that script to the body of your notification.

[Ankur Bawiskar · Accepted solution]

@Alex Saager1 

you can use a flow variable and concatenate the assets of that user by iterating using For Each

Then in single email use that flow variable to print all the assets

check how you can append/concatenate the assets in flow variable using For Each

If my response helped please mark it correct and close the thread so that it benefits future readers.

[J Siva]

Hi @Alex Saager1 
I believe you've set up your flow on the sys_user table. If yes, then you can try the below approach.
1. Create one email script to fetch all the assets which belongs to the current user.

    var emp = current.sys_id;
    var content;

    template.print('<table border="1"> <tr> <th>Asset ID</th> <th>Name</th><th>Custodian</th></tr>');

    var assets = new GlideRecord('alm_asset');
    assets.addEncodedQuery("assigned_to!=NULL^asset_tagISNOTEMPTY^assigned_to="+emp); // MODIFY THIS QUERY AS REQUIRED
    assets.query();
    while (assets.next()) {
        var str = '<tr> <td>' + assets.asset_tag + '</td> <td>' + assets.display_name + '</td> <td>' + assets.getDisplayValue('assigned_to') + '</td> </tr>';
        template.print(str);
    }
	
    template.print(' </table>');

2. Create a notification with the "Send When" value is 'triggered'

3. Call your notification in the flow using "Send Notification" action

Result:

Hope this helps.
Regards,
Siva