I’m able to get the SQL String but I’m not sure how to escape everything to make sure it’s valid in the Filter box option in the activity:
(“urn:schemas:httpmail:fromname” LIKE ‘%test@gmail.com%’ AND (“urn:schemas:httpmail:datereceived” >= ‘3/28/2021 8:45 PM’ AND “urn:schemas:httpmail:datereceived” <= ‘3/28/2021 8:46 PM’))
I tried this: (Basically putting double quotes around for every " or ')
“@SQL= " +”(“”“urn:schemas:httpmail:fromname”“” LIKE “'”%test@gmail.com%“'” AND (“”“urn:schemas:httpmail:datereceived”“” >= “‘“3/28/2021 8:45 PM”’” AND “”“urn:schemas:httpmail:datereceived”“” <= “‘“3/28/2021 8:46 PM”’”))"
Not working and I couldn’t find a compiler to help me out online.
Unfortunately the filter on email address did not work. I wonder if it’s cause in Outlook the email address doesn’t show up?
Is there a way to call on the UID with the filter property in the Get Outlook Message activity? Similarly I want to assign the UID to my queue item specific content so that I can refer to the right UID.