Extract the reviewer name and use that name in assignee field.

Question

When a ticket is created, the assignee field is Unassigned. What I am trying to achieve is to extract the reviewer name from the requirement fields. Use that name in the Assignee field

The requirement field in the ticket looks like this:

Link: xxx.com (SharePoint link)
Reviewer: {"ABC":"ABC"} (The names extracted from SharePoint)
Owner: ABC (The names extracted from SharePoint)

The reviewer can contain more than one name. The first name goes to Assignee field and remaining goes to collaborator, if it is doable.

I created the flow, and I tried  a lot of things, but nothing seems to be working. My current flow is :

Trigger: Work item created

Action:
Created Variable

Variable nameAccess using {{reviewerRegex}}. Smart value
Reviewer:\s*\{\s*"([^"]+)"
Action:
Assign the work item
Assign the work item toSmart valueUser{{jiraUser(issue.description.match(reviewerRegex)).accountId}}

Can anyone please help me correct logic and condition?

Tasneem Talawala_es7gpl · Answer

With API the entire flow was different After Trigger I created two variable:

Name: reviewerName

Value: {{issue.Requirements.match("(?s)Reviewer:.*?\"([A-Za-z ]+)\"").trim()}}

Second Create variable

Name: reviewerEmail

Value: {{reviewerName.toLowerCase().replace(" ", ".").concat("@companyname.com")}

Status:200

Gor Greyan · Answer

@Tasneem Talawala

The query parameter needs to contain a value that Jira can match against a user's profile, their display name, or email address. If the value extracted from the Requirements field doesn't exactly match a user, the API can legitimately return an empty result.

Could you please share.

- Value you're extracting from the Requirements field,

- Request URL/body you're sending to the user search endpoint (masking any sensitive information)

- Response status code?

Tasneem Talawala_es7gpl · Answer

I tried using API but the body:empty which means the search didn't return any results