Read excel content certain words and email

Help Activities
, , , ,
4

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

image

5

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

6

@koolrc812

Replace E2 with your column name

7

ok, @sangeethaneelavannan1
forum.zip (6.6 KB)

8

ok,@koolrc812
forum.zip (6.6 KB)

9

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

10

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

11

ok,@koolrc812

image
image852×485 18.6 KB

image
image798×509 18.3 KB

12

can you try below screenshot
@koolrc812

13

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

14

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

15

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

16

@koolrc812

can you change variable type array of string

image
image854×218 15.9 KB

cheers

17

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

18

@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

2 Likes
19

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

image
image1366×768 92.2 KB

cheers

20

thanks heaps

1 Like
21

Thanks heaps works well!!!

22

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

23

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