https://community.splunk.com/t5/Dashboards-Visualizations/Quickly-add-list-of-inputs-to-dropdown-menu/m-p/619785#M50887 <P>Hey all!</P> <P>Hoping you can help. I am currently building a dashboard that will allow users to select a option from a dropdown menu, and then type in a username in order to see all events for that input for that user.</P> <P>I am in a bind however as the dropdown has several hundred options (unfortunately no way to slim that down) and I was wondering if there was a way to quickly and painlessly add the labels and inputs from a spreadsheet I have over into the dropdown, or if I have to go through and copy each of them individually.</P> <P>Any help would be greatly appreciated!</P> Tue, 08 Nov 2022 15:42:32 GMT Southy567 2022-11-08T15:42:32Z https://community.splunk.com/t5/Dashboards-Visualizations/Quickly-add-list-of-inputs-to-dropdown-menu/m-p/619785#M50887 <P>Hey all!</P> <P>Hoping you can help. I am currently building a dashboard that will allow users to select a option from a dropdown menu, and then type in a username in order to see all events for that input for that user.</P> <P>I am in a bind however as the dropdown has several hundred options (unfortunately no way to slim that down) and I was wondering if there was a way to quickly and painlessly add the labels and inputs from a spreadsheet I have over into the dropdown, or if I have to go through and copy each of them individually.</P> <P>Any help would be greatly appreciated!</P> Tue, 08 Nov 2022 15:42:32 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Quickly-add-list-of-inputs-to-dropdown-menu/m-p/619785#M50887 Southy567 2022-11-08T15:42:32Z https://community.splunk.com/t5/Dashboards-Visualizations/Quickly-add-list-of-inputs-to-dropdown-menu/m-p/619794#M50889 <P>You should be populating the dropdown list with a search.&nbsp; That search get collect values from your indexes or can get them from a lookup file (or other places).&nbsp; In the form below, your SPL (perhaps <FONT face="courier new,courier">| inputlookup options.csv</FONT>) goes in the "Search String" box.&nbsp; The name of the field you want to show to users goes in the "Field For Value" box.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="richgalloway_0-1667783487372.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/22362i6768A328BA0736CE/image-size/medium?v=v2&amp;px=400" role="button" title="richgalloway_0-1667783487372.png" alt="richgalloway_0-1667783487372.png" /></span></P><P>&nbsp;</P> Mon, 07 Nov 2022 01:13:16 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Quickly-add-list-of-inputs-to-dropdown-menu/m-p/619794#M50889 richgalloway 2022-11-07T01:13:16Z