Custom dropdown field in Jira with data from an Excel file

Question

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

Chalani De Silva · Answer

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.

Maelle Cartron - Elements · Answer

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

Cristian0791 · Answer

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.