Read excel content certain words and email

[koolrc812 (RC)]

Hi, How do read an excel and recognize with certain words and send email?
eg. Excel from cell E2 to E100 if recognize with words “New York” or “LA” then will send an A template.
If recognize in cell E2 to E100 with words “Florida” or “Las Vegas” will send B template.

Do I use if and read range activities? Please help.

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

@koolrc812

E2 to E100

Hi @koolrc812
Read range activity to store the data from excel
Inside if yourDT.AsEnumerable().Any(Function(x) x(“Column1”).ToString = DesiredValue then send template A to mail

[Kalimuthu_Kalimuthu (muthu)]

Hi,@koolrc812 ,
can you check below xaml file and
Main.xaml (11.2 KB)

[koolrc812 (RC)]

Hi
Do you mean the below flow? anything I missed? please share screenshot flow chat. I think I missed some steps?

[koolrc812 (RC)]

Document is invalid, cant open. please send again. Thanks heaps

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

@koolrc812

Replace E2 with your column name

[Kalimuthu_Kalimuthu (muthu)]

ok, @sangeethaneelavannan1
forum.zip (6.6 KB)

[Kalimuthu_Kalimuthu (muthu)]

ok,@koolrc812
forum.zip (6.6 KB)

[koolrc812 (RC)]

not sure why still showing document is invalid? Could you please help to share screenshot?
Thanks

[koolrc812 (RC)]

showing " [option strict on disallows implicit conversions from ‘string’ to ‘boolean’].
I changed = to Contains.(“New York”) but still doesnt work.

[Kalimuthu_Kalimuthu (muthu)]

ok,@koolrc812

[Kalimuthu_Kalimuthu (muthu)]

can you try below screenshot
@koolrc812

[koolrc812 (RC)]

May i please know E1_list variable type is string or System.Data.DataTable? but both doesnt work?

[Kalimuthu_Kalimuthu (muthu)]

@koolrc812
No @koolrc812 E1_list variable type is sytem.string

[koolrc812 (RC)]

dt_countries - DataTable?
dt_countries.AsEnumerable.Select(function(x) x(“countries”).ToString).ToArray showing compiler error(s) encountered processing expression … value of type ‘1-dimensional array of String’ cannot be converted to ‘String’.?

[Kalimuthu_Kalimuthu (muthu)]

@koolrc812

can you change variable type array of string

cheers

[koolrc812 (RC)]

this part works. Thanks heaps.
for the below part if condition not sure why it shows - compiler error(s) encountered processing expression … [Option Strict On disallows late binding]?

[Anil_G (Anil Gorthi)]

@koolrc812

Did you change the type argument in for loop properties to string?

Change that and it should solve that issue…hope this helps

Cheers

[Kalimuthu_Kalimuthu (muthu)]

ok @koolrc812
change loop type in string and its work fine.

cheers

[koolrc812 (RC)]

thanks heaps