Custom dropdown field in Jira with data from an Excel file

[Chalani De Silva]

Is it possible to setup a customized Jira field dropdown to dynamically collect the data from Excel? For example, I would like to add a drop-down field added to an issue type and the data on the drop-down field should collect from an excel sheet in SharePoint

[Marcus Jacobs]

Hi @Chalani De Silva 

not out of the box afaik. There are apps for that like:

https://marketplace.atlassian.com/apps/23337/elements-connect-formerly-nfeed?hosting=cloud&tab=overview&utm_source=cocloud_beta&utm_medium=atlassian_community&_ga=2.216351254.140234934.1592206861-358779954.1591955214

or

https://marketplace.atlassian.com/apps/1219994/external-data-for-jira-fields?hosting=cloud&tab=overview

[Maelle Cartron - Elements]

Thank you @Marcus Jacobs !

[Maelle Cartron - Elements]

Hi @Chalani De Silva 

As @Marcus Jacobs  said above, you can use Elements Connect to dynamically retrieve and display external data within Jira custom fields. However, at this time, our integration supports connections to databases and REST APIs. If you have a database system where you can export your Excel data, you'll be able to configure the connection through Elements Connect and populate your custom fiels accordingly. 

If you need a demo or more info on your use case, feel free to reach out or book a meeting with our product manager!

Best Regards. 

Maëlle

[Chalani De Silva]

Thank you @Maelle Cartron - Elements and @Marcus Jacobs for the prompt responses. Will go through the recommended apps and get back to you if need more information.

[Cristian0791]

Hi Chalani,

You can mannualy uploaded from CSV file.

Here is a workarround:

https://community.atlassian.com/t5/Jira-Service-Management/How-to-Bulk-Update-Custom-Field-Type-Drop-down-in-Jira/td-p/2754796

Hope this helps.