How to set the reporter based on text contained in the description field using Look-up table.

Question

Hi, i created a lookup table that contains key = {{issue.description.contains("Text")}} and the value =  email address.

How do i set the reporter to the value returned by the lookup table. I tried updating the reporter with {{table.get(issue.description)}} but this does not work.

Jeroen Poismans · Answer

Have you seen the linked article? Set the reporter field with the Account ID (which could be in a variable smartvalue) and that should be it.

Jason Phillips_u9zocw · Answer

I basically want to do this using a lookup table

Jeroen Poismans · Answer

Hi Jason and welcome to the community!

To set a reporter via automation in cloud, you will need the Atlassian Account ID, not the email address. So you got 2 options:

* Make the lookup table so it returns the Account ID
* Lookup the Account ID form the email address (using WebRequest action)

For the second solution, I have posted an answer to a similar question right here:

https://community.atlassian.com/forums/Jira-Service-Management/Automation-captures-email-from-summary-and-changes-reporter-in/qaq-p/3102247

Scroll down to the answer, it explains how to get the Account ID.

Hope this helps!