Hi,
Does anyone knows how to filter based on destination ?
It’s quite urgent.
I really hope anyone could share some ideas?
Regards,
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,
Hi,
It is regarding the outlook.
Have to filter based on the destination from the subject.
Regards,
1 Like
Could you tell us clearly about what to filter here? @jnarthan.g
Hi @jnarthan.g
Check this expression out if your looping your list of mail message
item.Subject.Contains("your subject")
Also just check this post for your reference @jnarthan.g
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,
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,
Hi,
Can you share the worksheet?
Basically, we ca filter it using FiliterDataTable activity, as the following , for example.
Regards,
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
Hi,
What worksheet do you mean.
I think I already share now ya.
Regards,
Hi,
Can you do and show me a worksheet as an example.
Would be more easier to refer it.
Regards,
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.