How to print value based on user input

[Rakesh_Tiwari]

Hi All,

i have one more usecase, where i want to get the value based on user input.

i am trying to automate -https://coinmarketcap.com/.

there is a name column and price column, i have taken top 3 company name and build a datatable and after that i used an input dialogbox, then i extracted price of each three using get text activity.

And added those values to datatable variable, now i want to print the price based on user input, there i stuck in logic.

let say if user is typed Bitcoin, it should show bitcoin price value.

i am attaching my xaml file as well, kindly check.Main.xaml (9.4 KB)

[lakshman (Ganta lakshman)]

@Rakesh_Tiwari

1. Let’s say your DataTable contains two columns - Name and Price and its name is ‘InputDT’.

2. And then try below expression.

      varPrice = InputDT.Select("Name = '"+varName+"')(0)("Price").ToString
   

Where varName will be output of Input Dialog activity.

[Gokul001 (Gokul Balaji)]

Hi @Rakesh_Tiwari

Check with the workflow!!
Main.xaml (11.9 KB)

Hope it will work

Regards
Gokul

[Rakesh_Tiwari]

Hi Gokul,

here is output i am geeting.

i selected bitcoin as a user input and getting like this as o/p.

[Gokul001 (Gokul Balaji)]

Hi @Rakesh_Tiwari

These are the format you need to give in the Input Dialog box

• Bitcoin
• Ethereum
• Tether

Can you check with the Format?

Refer the screen

Regards
Gokul

[Rakesh_Tiwari]

ok, how do you pick the stable selector.

i have changed the AA name with *, but not getting the exact value.

[Gokul001 (Gokul Balaji)]

Hi @Rakesh_Tiwari
Check with updated workflow!!
Main.xaml (12.6 KB)

Regards
Gokul

[Rakesh_Tiwari]

ok, i go it.

Thanks