Condition based on subject contents with auto reply to sender if not met.

(0) Share

Report

Posted on by Torgil

I'm quite new to this.

I'd like to create a condition based on the contents of the mail subject when extracting attachements from email.

I need the following to be done (if possible).

The email subject must start with the following string "PL ###-#### ####" all mails must start with PL, the # indicates a number that is variable from mail to mail but it must be in this exact format.

e.g "PL 111-2222 3333" or "PL 555-1234 8974"

If the condition is not met i'd like the flow to give an auto reply to the sender.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

hi @Torgil pleasee see this is what you need

I add inside compose action your email subject then I get the lenght to see if some users sends you a code with less numbers as the correct format then send email or if don't contains PL send email.

Hope you this helps you.

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (0)

Report
Hi @Torgil ,

Please refer to screenshot below to create the flow with Condition:

The expression in the Compose 2 as below:

string('PL ')

The expression in the Compose 3 as below:

substring(outputs('Compose'),6,7)

The expression in the Compose 4 as below:

string('-')

The expression in the Compose 5 as below:

substring(outputs('Compose'),11,1)

The expression in the Compose 6 as below:

string(' ')

Best regards,

Alice

Community Support Team _ Alice Zhang
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
Torgil 8 on at

Like (0)

Report

Hi @v-alzhan-msft
Thank you for the help this seems to work with one exception.
When the subject of the mail contains less than 12 "characters" the flow will stop on and generate an error.

It stops on either compose 3 or compose 5 depending on how many characters the subject of the mail consists of.

This is the error code:
InvalidTemplate. Unable to process template language expressions in action 'Compose_3' inputs at line '1' and column '21541': 'The template language function 'substring' parameter is out of range: 'start index' must be non-negative integer and should be less than the length of the string. Please see https://aka.ms/logicexpressions#substring for usage details.'.

Do you have a way to correct this issue?

And again many thanks so far.

Torgil

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Hi @Torgil ,

Sorry for the solution would only work for PL 111-2222 3333 that you shared has 16 characters.

If sometime don't have 16 character, you could delete the special part.

Best regards,

Alice

Community Support Team _ Alice Zhang
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
Torgil 8 on at

Like (0)

Report

Hi again @v-alzhan-msft

Not quite sure what you mean with deleting of the special part?

Kind Regards
Torgil

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Hi @Torgil ,

I means you only check if the subject start with PL .

Best regards,

Alice

Community Support Team _ Alice Zhang
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
Torgil 8 on at

Like (0)

Report

Hi @v-alzhan-msft

Ok, then i think that the first example will work better for me. As it normally shouldn't be a problem.
There's no way around to solve this in other ways?

Again very much thanks for the help, it provided me with a lot better understanding on how this works.

Kind Regards
Torgil

Was this reply helpful? Yes No