Need help with Automation and lookupIssues

[Kathy Dickason]

I have a custom field called "Percent Done" (single-line text) on my Epic screen that contains a number.

I am trying to figure out if I can use an Automation (lookupIssues?) that will locate all Epics linked to an Initiative, and average the Percent Done fields in those epics, then display that result in a Percent Done field on my Initiative screen. 

I am seeing articles from 2020 that says you cannot use lookupIssues with custom fields. Is that still the case? Can someone help me with an automation that will help me determine the Initiative Percent Done field by averaging the numbers in the Percent Done field of my linked Epics?  This is Data Center (not Cloud). 

[Bill Sheboy · Accepted solution]

Hi @Kathy Dickason 

You are correct: for Jira Server / Data Center automation, the Lookup Issues action only supports a small number of fields at this time.

There are two possible workarounds, depending upon your needs.  To use the average value you describe to set another field, you may use the Send Web Request action to call the issue search REST API endpoint.  Please see this earlier question I answered to describe the details:

https://community.atlassian.com/t5/Automation-questions/Automation-Custom-Fields-Lookup-issues-not-working/qaq-p/2696054#M10504

Kind regards,
Bill