Automation: Take substring in summary

[Soporte]

We receive requests through an email, and it always has the same structure:

Summary = Voicemail message (666666666> 7768) From: 666666666

I am creating an automation to extract that phone number and check if it exists among our clients.

In the JQL, I have used: project = SOPLEX AND summary ~ '{{issue.summary}}'

to obtain a list with that phone number in {{lookupIssues}} and perform the initial check.

However, in the Logging Action, I am trying to display the phone number like this:

The customer's phone number is: {{lookupIssues.substringAfter("From:")}}

and I am not getting the result: The customer's phone number is:

Is this how the substring is obtained, or is there another way?

Thank you in advance.

[Riley Sullivan · Accepted solution]

Hello @Soporte 

Super close, and you were on the right track. For this scenario, you would not need to use lookup issue. You can just use the Jira smart value for the issue.

{{issue.summary.substringAfter("From: ")}}

---

The customer's phone number is: {{issue.summary.substringAfter("From: ")}}

Hope this helps!

[Soporte]

And can I tell you to be a maximum of characters? that is, from "From: " +9 characters

Thx 4 all

Note: 

putting it in lookupIssues, is to then take a list of previous calls and assign previous values to the new issue

[Riley Sullivan]

This is possible:

{{issue.summary.substringAfter("From: ").left(9)}}

There are a few ways you can mix some of these logics together from this article.

[Soporte]

Perfect, thank you very much!