Filtering base on destination

Help Activities
, , , , , ,
1

Hi,

Does anyone knows how to filter based on destination ?
It’s quite urgent.
I really hope anyone could share some ideas?

Regards,

2

HI,

Can you elaborate? Do you need to filter regarding Outlook?
In general, we can use content of MailMessage.To or MailMessage.Cc for filitering

Regards,

3

Hi,

It is regarding the outlook.
Have to filter based on the destination from the subject.

Regards,

1 Like
4

Could you tell us clearly about what to filter here? @jnarthan.g

5

Hi @jnarthan.g

Check this expression out if your looping your list of mail message

item.Subject.Contains("your subject")

6

Also just check this post for your reference @jnarthan.g

https://forum.uipath.com/t/filter-in-getoutlookmailmessages

7

Hi,

How about the following?

image
image917×458 18.4 KB

Regards,

8

Main.xaml (29.1 KB)
Hi,

This is what I did so far.
I need to filter base on the destination from the subject. It will generate a excel file and that is what need to be filted.

Hope you might understand.

Regards,

9

HI,

Do you want to improve this Switch? Or process after this?

image
image933×609 15.5 KB

Regards,

10

Hi,

As you can see this are the destination which will extract from the email subject.
So after that it will go in a software call gallileo and generate a suggestion list which in excel file. That excel file is what need to be filtered.
Hope you understand.

Regards,

11

Hi,

Can you share the worksheet?
Basically, we ca filter it using FiliterDataTable activity, as the following , for example.

image

Regards,

12

@jnarthan.g

You can read the data from excel into a datatable dt

Then use filter datatable activity to filter the required column on the provided value…

Alternately you can also use linq to filter …which can be used in assign

Filtereddt = dt.AsEnumerable.Where(function(x) x("ColumnName").ToString.ToUpper.Contains("FONTANA").CopyToDataTable

This also will give the filtered table…

Cheers

13

Hi,

What worksheet do you mean.
I think I already share now ya.

Regards,

14

Hi,

Can you do and show me a worksheet as an example.
Would be more easier to refer it.

Regards,

15

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