Get Mail Office 365 Activity: need filter query for multiple sender email address

I am stuck with a scenario where I need to add filters in Get Mail activity for multiple senders and Sender email address are in Config file.

My current filter is from/emailAddress/address eq ‘xyz@domain.com’ which is returning unread email count. However if I Change the above filter to read email for multiple sender from config file below filter is not working for example:

from/emailAddress/address eq ‘"+Config(“TesteMailFrom”).ToString+"’"
or
contains(from/emailAddress/address,‘"+Config(“TesteMailFrom”).ToString+"’"

Can you help?

1 Like

Hello @skg_161125!

It seems that you have trouble getting an answer to your question in the first 24 hours.
Let us give you a few hints and helpful links.

First, make sure you browsed through our Forum FAQ Beginner’s Guide. It will teach you what should be included in your topic.

You can check out some of our resources directly, see below:

  1. Always search first. It is the best way to quickly find your answer. Check out the image icon for that.
    Clicking the options button will let you set more specific topic search filters, i.e. only the ones with a solution.

  2. Topic that contains most common solutions with example project files can be found here.

  3. Read our official documentation where you can find a lot of information and instructions about each of our products:

  4. Watch the videos on our official YouTube channel for more visual tutorials.

  5. Meet us and our users on our Community Slack and ask your question there.

Hopefully this will let you easily find the solution/information you need. Once you have it, we would be happy if you could share your findings here and mark it as a solution. This will help other users find it in the future.

Thank you for helping us build our UiPath Community!

Cheers from your friendly
Forum_Staff

Hey @skg_161125

You are sure that the hard-coded value worked right ?

Also please print the config value once before executing the condition to make sure there is no errors.

Thanks
#nK

yes, even when I have only one email address in config variable using from/emailAddress/address eq ‘"+Config(“TesteMailFrom”).ToString+"’" filter, I can read the emails but If I have multiple email address to read emails from, above filter doesnt return any email count.

1 Like

Did you please print the above in a log message?

In log message I see 2 email addresses in Config(“TesteMailFrom”).ToString.

1 Like

Sorry 2 email messages meaning ?

i meant address, updated the above previous reply.

1 Like

You are saying it is printing 2 email ids right ?

Correct, it is printing 2 email IDs. However having Config(“TesteMailFrom”).ToString in the Get Email query to read email from. It is returning 0 emails. I have 2 unread emails in the inbox from each of the email ID.

1 Like

As you said since it’s printing 2 that’s d issue.

but that is the requirement…email can come from any one of email ID and based on email from only those 2 email ID, my process should proceed.

1 Like

Cool, please try with one email first and confirm whether it’s working.

Output of GET EMAIL activity when I have 2 email IDs in the Config(“TesteMailFrom”).ToString
image

Output of GET EMAIL activity when I have 1 email IDs in the Config(“TesteMailFrom”).ToString