Get Outlook Mail Message Filtering Subject and Sender

[srobey888]

Hello all,

I will start out by saying this might not be possible.
My current flow gets outlook mail messages from the last 30 days from multiple inboxes which can be over 10000, and checks for changes in categories and outputs to a spreadsheet. The flow usually fails after a few hours because it’s so large.

Is there a way to use the filter in get outlook mail messages to look at the spreadsheet and tell the bot to only look for the matching sender and subject from the spreadsheet.
This does not work “[Subject] = '” & row(“Subject”).ToString & “’ AND [SenderEmailAddress] = '” & row(“Sender”).ToString & “'”.

For example: If the spreadsheet has the sender “John” and the subject “Finish report”, I do not want the bot to check 10000 emails to find it, rather the bot has the filter to only look for the sender and subjects from the spreadsheet and updates only those categories.

[srobey888]

@anyone have a possible solution to this?

[ranjith_udayakumar]

Hi @srobey888 ,

The best approach is to create a outlook rule with the filters you want(Subject and From Address condition) to move the emails to certain folder.

Use Get Outlook Mail Messages and in the MailFolder property specify the folder name like ‘Inbox\Finished Reports’ or ‘Finished Report’ (if it is at root level instead of within inbox folder) you used in outlook rule.

Hope it helps…

Regards,
Ranjith Udayakumar

[srobey888]

Hi ranjith, I thought of those, but as far as I know the outlook rule can’t get all subjects and froms, only specific ones that are hard coded in.

[ranjith_udayakumar]

Hi @srobey888 ,

You can achieve that with Outlook Rule itself, Refer this link - Redirecting