Help with activites and sequence

[Ricchch (Ricardo)]

Hello everybody,
I would really appreciated if you could help me with this problem:
I need to filter in emails in outlook. However, outlook-inbox has differents folders.
Please look at the picture joined here

As you could notice, my inbox has differents folders levels.

i would like to set an activity in Studio which will go directly to one of the folders and taking its name (string) as an indicator to select the folder i will apply other instruction (filters)…

Any idea would be very appreciated , thanks
Ricardo

[Anil_G (Anil Gorthi)]

@Ricchch

Use get outlook mail message in the folder give the foler path like "Inbox\Business\Projects\Ananke"

It has a filte rproperty where jet or dasl queries can be used

Hope this helps

Cheers

[Ricchch (Ricardo)]

@Anil_G
Thank you very much for helping.
Just last question…please
i am trying to use “Get Outlook Mail Message” to filter 4 types of criterions ( if emails are unread, if they have an excel attachments (.csv ; xlsx; xls) and if they have red category).

as you see in the photo below, i 'm using options to set these filters:
but i can’t make the Expression editor to set a phrase code to make those 4 criterions to work…

I need a code-phrase (instruction) to filter: just excel files (types csv;xlsx;xls) AND Red category

Could you please help me with that?

Thanks in advance,
Ricardo

[Anil_G (Anil Gorthi)]

@Ricchch

Please try this

"@SQL= ""urn:schemas:httpmail:hasattachment"" = true AND ( ""urn:schemas:httpmail:attachmentfilename"" LIKE '%.xlsx' OR ""urn:schemas:httpmail:attachmentfilename"" LIKE '%.xls' OR ""urn:schemas:httpmail:attachmentfilename"" LIKE '%.csv' ) AND ""urn:schemas:httpmail:category"" = 'red'"

Edited : True instead of 1

Cheers

[Ricchch (Ricardo)]

Thanks very much @Anil_G
Have a good weekend

[Anil_G (Anil Gorthi)]

@Ricchch

Is it throwing error somewhere?

If yea remove the brackets

And move category statement with and condition before or conditions

Cheers

[Ricchch (Ricardo)]

Hello,
i just tried remplacing true instead of 1 … and it works.
Thank you very much…

Ricardo

[Ricchch (Ricardo)]

@Anil_G,
Hello Anil_G,
hope you are doing well .
I tested the code you sent to me in the “Get Outlook Mail Messages”

“@SQL= ““urn:schemas:httpmail:hasattachment”” = true AND ( ““urn:schemas:httpmail:attachmentfilename”” LIKE ‘%.xlsx’ OR ““urn:schemas:httpmail:attachmentfilename”” LIKE ‘%.xls’ OR ““urn:schemas:httpmail:attachmentfilename”” LIKE ‘%.csv’ ) AND ““urn:schemas:httpmail:category”” = ‘red’”

and i selected unread message and this is my outlook (there are just 4 unread message . what is more there is just 1 email with string ATCP
so that i should have just one “correct” in the ouput pannel as a result .

However, i notice that it went through all the emails…

REsults after running

Would you please help me how to find my mistake ?
Thanks,
Ricardo

[Anil_G (Anil Gorthi)]

@Ricchch

First can you filter with unread may be there are old unread mails also…and can you try printing the subject of each mail so that we can check what those are…

And yes as atcp is only one you got correct log only once

Cheers

[Ricchch (Ricardo)]

Thanks @Anil_G
Actually my checked twice my inbox and there is no other unread emails…
Thanks anyway for helping

[Anil_G (Anil Gorthi)]

@Ricchch

Did you try printing the subject lines to know which emails are those?

Cheers

[Ricchch (Ricardo)]

Hello @Anil_G,
Yes, and the subjects are those for the emails.
I think there is a bug …
so i am changing the strategy.
In the meantime: i am trying to use “For each email” activity instead of “For each”
to know if for each email could allow me to fix my filter problems
but it said i need a king of outlook account card…

Thanks for any suggestion of knowing what it means outlook account card…

[Anil_G (Anil Gorthi)]

@Ricchch

First of all you can use the additional filters on the for each loop for most of your cases…

Is the same filter you are looking as condition in outlook card?

Cheers