Link to request number in flow designer email notification

LK11 · ‎08-14-2018

Hi

Has anyone worked with flow designer to send an email notification with link to current request number?

Thanks

midjoule · ‎04-30-2019

Hi lk24,

I had the same requirement. The best I could achieve is simply writing the URL of the system (*) in the e-mail and appending the SYS_ID of the record from the data pill:

1. Create a flow designer action which retrieves the instance URL

2. In the Send Email action, build the URL:

Here is the result in outlook, which is converting the URL to a link:

Please mark as Correct if it resolved your issue.

View solution in original post

Sangita Swamina · ‎01-23-2020

Can someone please share how to build the action(base URL) into send email action as shown by midjoule? Thanks

Jared Kramer · ‎04-12-2022

When you put the data pill in the email body, you can then view the source. When you do, you can get the data pill value, which is some transform id. Just find something that says "data-pillvalue=" and copy the "{{fd-transform:xxxxxxxxxxx}}" part.

Then, when you insert the hyper link, just paste that value.

rm231 · ‎07-05-2022

Thanks, Jared. But I got the following when opening the link: https://xxx.service-now.com/8572520987a8151068eaffb2debb35a4

The working link should be this in my environment: https://xxx.service-now.com/nav_to.do?uri=sn_compliance_rk_training.do?sys_id=17ec52f087e8d11068eaffb2debb3521

How do I fix this? Thanks!

Jared Kramer · ‎07-08-2022

What I had done was set a Flow variable that was a string of the instance URL. When I did the whole Insert Link, the URL part looked like this:

{{fd_transform:21f9dc63-37d9-44d6-a734-a9611ab59213}}service_portal?id=ticket&table=sc_req_item&sys_id={{fd_transform:e102cb2f-f515-4b26-aa05-e8f86dcf0738}}

The first {{fd_transform:xxxxxxx}} was the Flow variable I set previously and the second "{{fd_transform:xxxxxx}} was a reference to the Requested Item sys_id.

In your case, I think your URL would look like this:
{{fd_transform:xxxxxxx}}nav_to.do?uri=sn_compliance_rk_training.do?sys_id={{fd_transform:xxxxxxx}}