Get Outlook Mail Activity - variable in filtering subject

[Kindergarden]

Hi,

Can I pass a variable into the filter option of the get outlook mail activity. What is working now is hardcoded below. Thanks.

“@SQL=” + “”“” + “urn:schemas:httpmail:subject” + “”“” + " like ‘%hello world%’"

[lakshman (Ganta lakshman)]

@Kindergarden

Try this:

“@SQL=urn:schemas:httpmail:subject LIKE '%”+variableName.Tostring+"%’ "

[Kindergarden]

wow. thanks man, I will try and let you know.

[Kindergarden]

Hi @lakshman

It’s working! Thanks.

May I know if it will also work if I read the variable from excel. For very row, it’s different subject. Then issue the variable in the row.item format? Eg.
“@SQL=urn:schemas:httpmail:subject LIKE '%” + row.Item(1).ToString + “%'”

Thanks !

[Palaniyappan (Palaniyappan P)]

Hi
you were almost done
you need to mention like this buddy if you are getting from a excel with for each row loop

“@SQL=urn:schemas:httpmail:subject LIKE '%” + row(“Columnname”).ToString + “%’”

or

“@SQL=urn:schemas:httpmail:subject LIKE '%” + row(1).ToString + “%’”

where 1 is the column index which usually starts with 0

Cheers @Kindergarden

[Kindergarden]

Thanks @Palaniyappan.

I got it. May I also know why the below-mentioned works
emailList.Count.ToString > row.Item(2).ToString
but this one emailList.Count.> row.Item(2) does not work as I am comparing number value.

[lakshman (Ganta lakshman)]

@Kindergarden

Because both are different type of variables.

[Kindergarden]

Also, what if I have a shared mailbox ? How do I indicate this is the MailFolder opion instead of hardcoding “inbox”?

[Palaniyappan (Palaniyappan P)]

fine
you are trying to compare a integer value and string
i.e., the emaillist.Count is of type integer as count gives us numerical value
and row.Item(2) gives us string value
as the > operator can’t be used with string and more over the two operands must be of same type…and as these two things are missing here in the expression you were not able to compare

and if you want to include shared mail box
you can mention like this in folder property
sharedmaill email id/Inbox/Foldername

this could help you on this

Can't get to Exchange shared mailbox folders

Hi Community, I’ve updated UiPath.Mail.Activities to version 1.2.6863.29868 but there is still a problem with getting emails from shared mailbox folder other than Inbox using Exchange Get Mail activity. However the release notes states that it was fixed… No matter the syntax of the folder name it throws an error “folder not found”. It returns emails without a problem when folder is set to “Inbox” only. I’ve tried “mailbox@domain.com/Inbox/folder name” and “Inbox/folder name” and “/Inbox/folder…

Cheers @Kindergarden

[Palaniyappan (Palaniyappan P)]

did that work buddy @Kindergarden
Cheers

[Kindergarden]

Thanks @Palaniyappan

I see. That means if I have a shared mailbox called ‘GroupA Meal Mailin’ and a folder ‘lunch’, then I should indicate in MailFolder as “GroupA Meal Mailin/lunch” right ?

I suppose I also could input “GroupA Meal Mailin/lunch” in excel and input in MailFolder as row.Item(3).ToString as a variable ?

[Palaniyappan (Palaniyappan P)]

@Kindergarden

I see. That means if I have a shared mailbox called ‘GroupA Meal Mailin’ and a folder ‘lunch’, then I should indicate in MailFolder as “GroupA Meal Mailin/lunch” right ?

that should be a mail id…
yah you can pass with a variable @Kindergarden

[Kindergarden]

Thanks. I have posted another request for help and tinker you guys. Please help check it out too. In the meantime, I will check out the shared mail box.

[Kindergarden]

hi @Palaniyappan

I thought i read somewhere one could have multiple filter condition. Please advise if my syntax is correct. I would like to add From to tighten the filter but it failed below.

“@SQL=urn:schemas:httpmail:subject LIKE '%” + row.Item(0).ToString + “%'” and “urn:schemas:httpmail:from LIKE ‘%MrABC%’”

[Kindergarden]

Hi @Palaniyappan

The variable in folder does not work. I input row(3).ToString.

Tried to input excel as inbox which is default also won’t work. The shared mailid in the format GroupA Meal Mailin/lunch similarly also doen’t work.

Both instances error on The Specified Folder does not exist. Strange right? I think I read somewhere too that it’s possible to pass in folder as variable but now sure about row.item though.

[Kindergarden]

Hi @Palaniyappan,

The variable for folder is working now. But it’s not working for shared mailbox. Even when I hardcode the value “GroupA Meal Mailin/lunch” into the folder, it still run into error Specified Folder does not exist. Any idea if really shared mail id is support in the Mail Folder input of Get Outlook Mail activity?

[Palaniyappan (Palaniyappan P)]

@Kindergarden

“GroupA Meal Mailin/lunch”

it should be mail id , kindly refer this post

Can't get to Exchange shared mailbox folders

Hi Community, I’ve updated UiPath.Mail.Activities to version 1.2.6863.29868 but there is still a problem with getting emails from shared mailbox folder other than Inbox using Exchange Get Mail activity. However the release notes states that it was fixed… No matter the syntax of the folder name it throws an error “folder not found”. It returns emails without a problem when folder is set to “Inbox” only. I’ve tried “mailbox@domain.com/Inbox/folder name” and “Inbox/folder name” and “/Inbox/folder…

cheers

[Kindergarden]

Hi @Palaniyappan

I browse through and it seems no solution as yet. Is that what u r trying to sugegst ?

Also, u mnetioned should be mail ID as in I should enter “GroupA Meal Mailin” in Account input instead and lunch in MailFolder ?

[Palaniyappan (Palaniyappan P)]

Fine
mention in folder as “Inbox/lunch”
and try @Kindergarden
cheers

[Kindergarden]

Thanks @Palaniyappan

Got it. I created variable for shared mailbox under Account. And the variable for folder under MailFolder. So, the confusion is with Account. Good that we share here. Thanks man !