Answered

Get Email V3 - Search Query

(0) Share

Report

Posted on by Matthew5

Hi there,

I understand that the get Get Email V3 flow is limited to the top 25 results. Would using a search query widen the number of emails the flow checks or are you still limited to only the top 25?

Use case - we're using PVA & Power Automate to check a shared mailbox to see if we've received an email from a specific email address. Due to this shared mailbox receiving 100s of emails, it's extremely likely the automated flow will return a response to state nil returns. When in fact there could have been an email received, it's just beyond the top 25.

Thank you

Categories:

General

All responses (4)

Answers (1)

Matthew5 on at

Like (0)

Report

Re: Get Email V3 - Search Query

Thank you so much. Working as I hoped now!

Much appreciated
Expiscornovus 31,732 Most Valuable Professional on at

Like (1)

Report

Re: Get Email V3 - Search Query

Hi @Matthew5,

You do not have to add the $Search query parameter itself, Microsoft is taking care of that. Only add the parameter value.

Try something like below
Matthew5 on at

Like (0)

Report

Re: Get Email V3 - Search Query

Thank you for your reply! You're quite right sorry, I've been running testing it does search beyond the first 25 emails, but it's good to know it is in fact 250.

It is likely I'll still need to search beyond the first 250 and I'm struggling to get the Search Query to work, if that's something you've got experience with at all?
Perhaps I'm using the incorrect syntax, as when I'm using $Search="From: example@contoso.com" it doesn't recognise the speech marks, it returns an error message.
If I use apostrophes, so using $Search='From: example@contoso.com' the flow will run correctly however it does not return any results despite there being an email there I know it should be able to check/return a result for.

Thank you
Verified answer

Expiscornovus 31,732 Most Valuable Professional on at

Like (1)

Report

Re: Get Email V3 - Search Query

Hi @Matthew5,

As far as I am aware the top property of the Get Emails (v3) action is for the number of items it will retrieve. That property does not say anything about the number of emails it checks.

I did find this text about the filtering:

This operation gets emails from a folder via graph apis. Please note that filtering related to these fields: To, Cc, To Or Cc, From, Importance, Fetch Only With Attachments, Subject Filter, is performed using first 250 items in a given mail folder. To avoid that limitation you can use 'Search Query' field.

https://docs.microsoft.com/en-us/connectors/office365/#get-emails-(v3)

With the search query field you will definitely check more items. I would use that in your setup.