Select Multiple Item

[suyash.saxena]

How to pass countries separated by comma present in excel file(Config.xlsx) in select Multiple Items in UiPath?
Input from config file row named Countries -
Austria,Belgium,France,Germany,Italy,Luxembourg,Netherland,Portugal,Spain,Switzerland

[Gokul001 (Gokul Balaji)]

Hi @suyash.saxena

Welcome to uipath community

You can try like this

{"Austria","Belgium","France","Germany","Italy","Luxembourg","Netherland","Portugal","Spain","Switzerland"}

Regards
Gokul

[suyash.saxena]

Thanks @Gokul001 for the help, but my input is dynamic and it is coming from config.xlsx file.

[varunk (Varun Kumar)]

Hi @suyash.saxena ,

Provide all the Country names in excel file.
Create a variable in string Array & call the row name from config file.

Try this It will work

[Gokul001 (Gokul Balaji)]

HI @suyash.saxena

Try with this expression

Split(yourString,",").ToArray

Regards
Gokul

[Yoichi]

Hi,

Can you try to set the following expression?

in_Config("Countries").ToString.Split(","c)

Regards,

[pravin_calvin (pravin kumar)]

Hi @suyash.saxena

Pass the Countries Separated by Comma in the Config File Like below.

And use the Config Variable and Convert to String and make a Split and Pass over the Multiple items field like
Config(“Countries”).toString.Split(new char(){ ","c }, StringSplitOptions.RemoveEmptyEntries)

Regards