Read excel content certain words and email

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


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


Replace E2 with your column name

ok, @sangeethaneelavannan1 (6.6 KB)

ok,@koolrc812 (6.6 KB)

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

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


can you try below screenshot

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

No @koolrc812 E1_list variable type is sytem.string

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’.?


can you change variable type array of string


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]?


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

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



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


thanks heaps

1 Like

Thanks heaps works well!!!

Thanks heaps. how do you put excel cell B2 and D2 text into email body when recongize its belong to A template?

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.