Cannot use Quotes in Search Query for Office 365 Get Emails

(0) Share

Report

Posted on by kylep

We're trying to search Office 365 emails from last week. The below query works in OWA, but gives an error in Flow.

(received:"last week")

status: 400

Syntax error: character '"' is not valid at position 22 in '"(received:'"last week"')

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

aprildunnam 704 on at

Like (1)

Report
Copy link

Link copied!

The syntax for Flow is different. In your Search Query of your O365 Get Emails Action use this instead: received:last week

See the attached screenshot for reference. That should return emails received last week.

Was this reply helpful? Yes No
kylep 15 on at

Like (1)

Report
Copy link

Link copied!

@aprildunnam Thanks for the reply, but that didn't work. It's runs successfully but doesn't pull any data without the quotes. Below is the full search query.

(received:"last week")AND(from:email@domain.com)

Was this reply helpful? Yes No
Verified answer

v-zhos-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @kylep ,

It seems you want to get the emils which are received last week.

I have made a test with the received:last week in the Search Query field.

However the output is [].

I suggest you use the ‘Filter array’ here.

The expression in Compose is: dayOfWeek(utcNow())

dayOfWeek

Return the day of the week from a timestamp.

The expression in 'Filter array' is to get the last sunday:

addDays(utcNow(),sub(0,outputs('Compose')),'yyyy-MM-dd')

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
panregitt 6 on at

Like (2)

Report
Copy link

Link copied!

Kylep,

Quotes are special characters so they must be escaped to be included as part of the query text. Please modify your Search filter text as follows

received:\"last week\"

I have found that for text lookups, the match is literal from the start of the text. It is not like in outlook that you can type a string and it will find all text that includes the string. For example in outlook client, if you type subject:val, it will find messages with value, valid, evaluated, oval in the subject. If you use the same criteria in flow, it will only match the word val.
Pd, and drop the parenthesis
Cheers
Fernando

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

Like (0)

Report
Copy link

Link copied!

@panregitt best answer for this issue. thanks

Was this reply helpful? Yes No