Power Automate - General Discussion

How to search emails in Get emails (V3) ?

(0) Share

Report

Posted on by VictorIvanidze

12,865

Hello people.

What's the proper syntax of search query in "Get emails (V3) "?

I need to select only NDR messages from Inbox and this string in the field "Search Query" just doesn't work:

MessageClass:REPORT.IPM.Note.NDR

Note that the same filter works fine in Outlook.

I have the same question (0)

All responses (10)

Answers (0)

manuelstgomes 6,625 on at

Like (0)

Report

Re: How to search emails in Get emails (V3) ?

Hi @VictorIvanidze

Get emails V3; the filter is the same as Outlook. Strangely, it doesn't work.

Can you please share the error so that we can validate it?

Was this reply helpful? Yes No
VictorIvanidze 12,865 on at

Like (0)

Report

Re: How to search emails in Get emails (V3) ?

No errors - it just returns nothing.
Could you please try to search NDR's in your Inbox?

Was this reply helpful? Yes No
manuelstgomes 6,625 on at

Like (0)

Report

Re: How to search emails in Get emails (V3) ?

Hi @VictorIvanidze

Indeed it's strange. I get results on my Outlook and no results running the Power Automate.

Probably someone else can chime-in, or it's probably a bug that needs to be solved.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Was this reply helpful? Yes No
VictorIvanidze 12,865 on at

Like (0)

Report

Re: How to search emails in Get emails (V3) ?

Well it looks like a bug. Can somebody confirm?

Was this reply helpful? Yes No
Community member on at

Like (2)

Report

Re: How to search emails in Get emails (V3) ?

The description of the field is clearly inaccurate and needs to be fixed.

This field maps to "$search" parameter - and this is documented in detail here: https://docs.microsoft.com/en-us/graph/query-parameters#search-parameter

I couldn't figure out a way to search for only NDR though - and the documentation above doesn't show that it supports searching on MessageClass.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: How to search emails in Get emails (V3) ?

Hi @SameerCh ,

I am trying subject:"@{items('Apply_to_each')?['WorkloadDisplayName']} : @{items('Apply_to_each')?['Status']} : @{formatDateTime(items('Apply_to_each_2').PublishedTime,'dd/MM/yyyy:HH:mm')}"

It is throwing an error as "Syntax error: character ':' is not valid at position 26

Please help

Was this reply helpful? Yes No
Community member on at

Like (0)

Report

Re: How to search emails in Get emails (V3) ?

Hi @Anonymous

Not sure where the error is coming from. One way to isolate the issue would be to see if the formula is correct first. To do that, you can perhaps try using the "Compose" action separately. It will tell you exactly how the expression is evaluated.

Then, you can pass the result in the Search parameter of your Get emails action.

HTH

Was this reply helpful? Yes No
i_power 76 on at

Like (1)

Report

Re: How to search emails in Get emails (V3) ?

I had the same problem. Turned out to be the double quotes ".

Changed to single quotes ' and then it worked.

Was this reply helpful? Yes No
jmbo 6 on at

Like (0)

Report

Re: How to search emails in Get emails (V3) ?

Yes, I confirm that I get no errors - it just returns nothing

Was this reply helpful? Yes No
Suggested answer

andy-clapham 25 on at

Like (1)

Report

How to search emails in Get emails (V3) ?

This is an old post but I seem to have worked out the "quirks" of the get emails v3 search box.

Looks like the developer forgot to escape the search parameter properly, instead they just added "s either side.

So you have to do quote escaping and url character encoding it yourself, as per https://learn.microsoft.com/en-us/graph/search-query-parameter?tabs=http

More details here:

https://community.powerplatform.com/forums/thread/details/?threadid=026ebb2b-a0ce-ef11-8ee9-7c1e5213dfe0

Was this reply helpful? Yes No