how to add a drop down to pick what csv lookup to use in a dashboard

[sbattista]

is there a way to add a drop down option to a dashboard that can change what csv lookup it uses? 

[sbattista]

thank you this will work for now, is there a way to make it less manual? can it auto populate the list of csv's based in a app context? 

[kamlesh_vaghela]

@sbattista 

I have updated my answer. Please check it.

KV

[kamlesh_vaghela]

@sbattista 

Try this sample XML. Here, I have created a.csv, b.csv and c.csv with sample data.

<form>
  <label>Dynamic Lookup</label>
  <fieldset submitButton="false">
    <input type="dropdown" token="tkn_csv_file">
      <label>Select File</label>
      <fieldForLabel>title</fieldForLabel>
      <fieldForValue>title</fieldForValue>
      <search>
        <query>| rest /servicesNS/-/-/data/lookup-table-files | where 'eai:acl.app'="$env:app$" | table title</query>
        <earliest>-24h@h</earliest>
        <latest>now</latest>
      </search>
    </input>
  </fieldset>
  <row>
    <panel>
      <table>
        <search>
          <query>| inputlookup $tkn_csv_file$</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">none</option>
      </table>
    </panel>
  </row>
</form>

Thanks
KV
▄︻̷̿┻̿═━一

If any of my reply helps you to solve the problem Or gain knowledge, an upvote would be appreciated.