How to pass a dropdown value in the lookup

[aditsss]

Hi All,

I have one requirement.

I have one dropdown as below:

<input type="dropdown" token="OrgName" searchWhenChanged="true">
<label>Org Name</label>
<choice value="accertify">accertify</choice>
<choice value="gcp">gcp</choice>
<choice value="b_marketingforce">b_marketingforce</choice>
<initialValue>gcp</initialValue>
<default>gcp</default>
</input>

Below is my query for the panel where I am passing the drop down value like below:

<query>|inputlookup HealthCheck.csv| where $OrgName$|table Date OrgHealth%</query>

But its not taking the token.

Can someone guide me .How I need to pass the token.

[scelikok · Accepted solution]

Hi @aditsss,

You need to use field name to filter lookup values, assuming lookup field name is for OrgName is OrgName try below;

<query>|inputlookup HealthCheck.csv where OrgName="$OrgName$"|table Date OrgHealth%</query>

If this reply helps you an upvote is appreciated.