Filter condition in microsoft office 365 for outlook get mail

Help Studio
1

I’m trying to filter out outlook mails in MIcrosoft office 365 using get mail activity, I want filter out mails by “sender and todays date or subject”. and I use following query
“contains(from/emailAddress/address, “+”'”+ SenderMail +“'”+“) Or contains(subject, “+”'”+ Subject +“') AND receivedDateTime ge '” + Now.ToString(“yyyy-MM-dd”) + “T00:00:00Z’ and receivedDateTime lt '” + Now.AddDays(1).ToString(“yyyy-MM-dd”) + “T00:00:00Z’”

In which i have two variables SenderMail and Subject as per my data.
and I’m getting an error
Get Mail: Code: BadRequest
Message: Invalid filter clause: A binary operator with incompatible types was detected. Found operand types ‘Edm.DateTimeOffset’ and ‘Edm.String’ for operator kind ‘GreaterThanOrEqual’.

2

@sagar.raval,

Not tested this but can you try this one:

"([SenderEmailAddress] = '" + SenderMail + "' OR contains(subject, '" + Subject + "')) AND [ReceivedTime] >= '" + Now.Date.ToString("yyyy-MM-dd'T00:00:00'") + "' AND [ReceivedTime] < '" + Now.AddDays(1).ToString("yyyy-MM-dd'T00:00:00'") + "'"