Filter in Get Outlook mail message

Help
21

Hey sorry again i m getting error message

“message”: “Get Outlook Mail Messages: Cannot parse condition. Error at "@SQL=(( ("urn:schemas:httpmail:subject" …".”,
“level”: “Error”,

22

Remove the filter string from filter property not required anymore

23

where you did the changes after removing filter it is again fetching all the unread mails not working with matching condition

24

Shall i share you my xaml folder where i am storing values and matching the subject?

25

I cant find any changes in my xaml…still its not working

26

Email Identification-Outlook.zip (28.0 KB)
In excel i m storing my unread mails

27

Can anyone please help me out

28

Hey @Snehamayi_Sneha,

I added an If condition inside your for each loop in main.xaml and removed the filter string from filter property now it should work.

Main.xaml (53.2 KB)

image
image1366×768 72 KB

29

yes but it is reading all the unreadmails :frowning:

30

it is reading all the unread emails but checking the subject inside the foreach loop if subject matches with the excel subject then it performs the next step.

what is your requirement.you do not want to read all the unread emails.

Get outlook message will only load the mail messages and you have the properties to select only unread messages and mark them as read.

1 Like
31

My scenario is:

  1. First time i read all the unread mails Get Outlook mail messages and not to make as read
  2. Then i am putting all my unreadmails to excel with subject and datentime.
  3. Then i used delay at that time i send a new mail to my email then i m using again get mail messages to compare with my excel subject with the new arrived mail if it is not there in excel it will add otherwise not .
    So just want those unread mails which came newly and add to excel
32

It is always matching the subject i dont know how when new mails come also

33

-In the first run read all the unread emails which you have processed and mark them as read.
-In the next run read only unread message.(in the second check after delay in the get outlook mail message check only unread email messages and uncheck mark as read.)

34

Yes thanks you are correct…
But my requirement is for the first run when bot reads the unreadmails we should not check that as read mails. Then how is it possible in the second run the bot should pick the fresh unread mails not all unread mails.

35

in the second run make sure you have checked read unread email property in the get outlook message.

36

Without checking unread mails is there any other options

37

No.Please try to follow the approach and let me know if that works or not.

38

This approach of making check to read files once its done its working fine…

39

But is it possible without unchecking the read files i need to add filter while getting outlook mail messages?

40

@Snehamayi_Sneha
Hi. PFA flow.GetMailMessage.zip (27.5 KB)