Automated Cloud Flow : Shared Mailbox Autoreply with case sensitive keywords (Value true or false not working)

(0) Share

Report

Posted on by Igerarts

Hello,

I am facing a problem when creating an automated cloud flow.

The idea is to create an autoreply system for a shared box but taking into account several keywords and especially taking into keywords case (uppercase and lowercase).

1) When an email arrives in a shared box, there is first a first control condition which checks that the sender's address is an external address and that there is no mention of Automatic Reply to avoid an infinite loop.

2) If this condition is validated, a second control condition begins. It checks that if the subject of the mail contains certain values (by checking the case of these values) then an automatic mail is sent. Otherwise, the process is cancelled.

My problem is the following, when I indicate that my expression is equal to "true", there is no departure of mail (whether the keywords are in the subject of the mail or not).

On the other hand, if I indicate that my expression is equal to "false" I do have a start of mail but also with the problem that the keywords are in the subject of the mail or not.

or (contains(toLower(triggerBody()?['Subject']), 'IRISBOX'),or (contains(toLower(triggerBody()?['Subject']), 'RENOLUTION'),contains(toLower(triggerBody()?['Subject']), 'PRIMES'),contains(toLower(triggerBody()?['Subject']), 'UR2'),contains(toLower(triggerBody()?['Subject']), 'REP-'),contains(toLower(triggerBody()?['Subject']), 'COMPLEMENT'),contains(toLower(triggerBody()?['Subject']), 'INCOMPLET'),contains(toLower(triggerBody()?['Subject']), 'RENOVATION'),contains(toUpper(triggerBody()?['Subject']), 'rénolution'),contains(toUpper(triggerBody()?['Subject']), 'rénovation'),contains(toUpper(triggerBody()?['Subject']), 'complément'),contains(toUpper(triggerBody()?['Subject']), 'toevoeging'),contains(toUpper(triggerBody()?['Subject']), 'onvolledige'),contains(toUpper(triggerBody()?['Subject']), 'premies'),contains(toUpper(triggerBody()?['Subject']), 'renovatie')))

Can you help me?

Thanking you,

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

VictorIvanidze 13,073 on at

Like (0)

Report

Hi @Igerarts,
do you mean that your second conditions is never returns true?

Was this reply helpful? Yes No
Igerarts 40 on at

Like (0)

Report

Hello VictorIvanidze,

If I set it equal to true it does not send an email (whether the words are in the subject or not).

If I set it equal to false, it sends the email but again whether the words are present or not.

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Are you kidding?
If the result of your second conditions is true, your flow should send an email.
If the result of your second conditions is false, your flow should NOT send an email.

Had your flow ever reach "Send an email" action?

Was this reply helpful? Yes No
Igerarts 40 on at

Like (0)

Report

So no I'm not kidding,

1) With equal true condition

a) Mail sent with one of the keywords which must trigger the sending of an autoreply

Result:

b) Email sent without one of the keywords which should trigger an autoreply to be sent

Result (Same):

2) With equal false condition

a) Mail sent with one of the keywords which must trigger the sending of an autoreply

Result :

b) Email sent without one of the keywords which should trigger an autoreply to be sent

Result (Same):

Was this reply helpful? Yes No
Verified answer

VictorIvanidze 13,073 on at

Like (0)

Report

Sorry I didn't notice it earlier - you have to change toLower and toUpper.

contains(toLower(triggerBody()?['Subject']), 'IRISBOX') always returns false.
You have to use
contains(toUpper(triggerBody()?['Subject']), 'IRISBOX')
and
contains(toLower(triggerBody()?['Subject']), 'irisbox')

Also please check if contains() function is really case -sensitive. If yes you do not need to use toLower/toUpper at all.

Was this reply helpful? Yes No
Igerarts 40 on at

Like (0)

Report

Hello @VictorIvanidze

great explanation it works

Thanks a lot,

Was this reply helpful? Yes No