When first input dropdown value changes run a query using it and set second drop down. How to do it?

[cshahfis]

Here first drop down Dates will display last 7 days of date. When user select any one date, query will be executed and that date will be used in query. Results of that query will be displayed in second query. I have tried below mentioned code but it's not throwing any error but my second drop down doesn't populate with correct values. Any pointers you provide will be helpful. Thanks.

<input type="dropdown" token="Dates" searchWhenChanged="true">
    <label>Date</label>
    <fieldForLabel>Dates</fieldForLabel>
    <fieldForValue>Dates</fieldForValue>
    <search>
        <query>| gentimes start=-6 end=+1
            | eval Dates=strftime(starttime,"%Y-%m-%d")
            | table Dates
        </query>
        <earliest>-15m</earliest>
        <latest>now</latest>
    </search>
    <default>2020-06-15</default>
    <initialValue>2020-06-15</initialValue>
    <change>
        <set token="form.name">
            <search>
            <query>index= test|rename body.recordTotals{}.from.* as from*|rename header.eventCode as eventCode|where eventCode = "abc" and fromfromUs="true" and messagingCalendarDate="$Dates$"|stats
                count by fromendPointName|table fromendPointName
            </query>
            <search>
        </set>
    </change>
</input>
<input type="dropdown" token="name" searchWhenChanged="true">
<label>Name</label>
<fieldForLabel>name</fieldForLabel>
<fieldForValue>name</fieldForValue>
<choice value="All">All</choice>
<default>All</default>
<initialValue>All</initialValue>
</input>

[ITWhisperer · Accepted solution]

The first dropdown change should set a token value. The second dropdown choices should be populated using the query with the token value selected in the first dropdown.