How to send emails using priority rules.

(0) Share

Report

Posted on by aouattara

Hello everyone,
Help please.

I have a sharepoint list with a dropdown column that has 3 possible values (No, Yes and Derog).

I would like to send emails with the following priority rules:

Firstly,

I do a filter on my data to take the rows that respect some conditions (Let's call the result of the filter Table A, which is a set of several rows).
Secondly,
If I have No, Yes and Derog in my Table A ==> I use Derog to send a Derog email;
If I have No and Yes in my Table A ==> I use Yes to send an email Yes
If I have Yes and Derog ==> I use Derog to send a Derog mail.
If everything is Yes ==> I send the mail Yes
If everything is No ==> I send the mail No
If all is Derog ==> I send the Derog mail.

Could someone help me with some ideas?

Thank you in advance

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

abouchaalaBAIT 932 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello @aouattara ,
I would :
Init variable array : varDrpValues
Get Table A
Set varDrpValues value to dropdown values. Ex ['Yes','Yes','No','Derog']
Switch
Case varDrpValues contains Yes and contains No and contains Derog...
Case varDrpValues and(and(not(contains(varDrpValues, 'Derog')),contains(varDrpValues, 'Yes')),contains(varDrpValues, 'No'))
etc ....
----------------------------------------------------------
If I have answered your question, please mark your post as Solved. 🆗✔️
If you like my response, please give it a Thumbs Up. 👍
You can accept more than one post as a solution.

Was this reply helpful? Yes No
aouattara 53 on at

Like (0)

Report
Copy link

Link copied!

@abouchaalaBAIT Thanks for your reply.
I would like to know how to use the "contains" condition in switch? Because it's the "equals" operator that switch has.
Below is a screenshot of part of the flow.

Was this reply helpful? Yes No
abouchaalaBAIT 932 Moderator on at

Like (0)

Report
Copy link

Link copied!

Oups, my bad. You ll need to use nested if switch case only accept static values

Was this reply helpful? Yes No
Verified answer

aouattara 53 on at

Like (0)

Report
Copy link

Link copied!

Hello @abouchaalaBAIT
The variable array didn't work.
Finally I created a csv table and used it in condition with the contains operator. It worked.
Thanks to your idea, I was able to take this other approach.
Thanks

Was this reply helpful? Yes No