Solved

Using Switch with check boxes on Form

  • 13 April 2021
  • 4 replies
  • 67 views

I need to be able to send various emails depending on which rate segment is selected on a form. The field is a check box that can be multi-selected. I am currently using switch and I know that switch can only use text or list ids. What would be the best and easiest approach to be able to send specific emails to each rate segment? Right now my workflow just skips entirely over the switch actions. Please see workflow screenshot attached. 

icon

Best answer by Aleximo 14 April 2021, 15:42

View original

4 replies

Badge +8

hey,


 


dont know if that would be an option for u, but i would work with "for each element"


 


it looks a bit clumsy but it works. let me know if ur interested and i explain it in detail:


 



 

yes I am interested! Please give me as much detail as possible so I can configure it correctly! Thank you!
Badge +8

okay.


 


so first u have to lookup the value from ur multiple choice field and save it in a collection varible (CollTopic)


 



 


 



 



 


 


after that u have to split ur values in the collection variable (CollTopic) and save the new values in another collection variable (or in the same CollTopic like i do)


 



 


 



 


now the last step:


 



 


in the for each element u have to create two variables one text and one YES/NO variable and set it up like this:


 



 


 



in the first "if else" we check if the varSingleValueTopic is empty:


 



 


 



if the variable is empty it will go to the right and set the YES / NO variable to Yes (this will stop the loop "for each"):


 



 


 



 


 


now the part is a bit repetitive... u have to do this step for each of ur single values that are possible to choose (PGS, Azusa, Space Components, Astro, Launch Vehicles, LV-MDS):


 


my example is for PGS:


 



 


set up the "if else" like this:


 


check if the text variable (varSingleValueTopic)  --- CONTAINS --- the value: PGS .... if its yes make an email notification on the "yes" path. if not then go to next "if else" and check if the text variable --- CONTAINS --- the value: Azusa.... and so on till all 6 are complete.


 



 


 


 


thats it.


 


let me know if u have any questions.


 


 

Badge +12

@Brook0131@Aleximo instead of hard coding everything in a workflow, below is my dynamic approach:


 


Create another list (restricted for the edit to certain users) and read-only for others. This will have the following columns:



  1. Rate Segment

  2. Subject (You can create the HTML code for common, item property, and workflow variable) or hard code the subject

  3. Body (You can create the HTML code for common, item property, and workflow variable) or hard code the message.


In your workflow:



  1. Using RegEx store rate segment choices in a collection variable

  2. Using For Loop for each value in the above collection:

    1. Using Query list query above list (filter using the current rate segment from a for loop) and get Subject & Body and store them in appropriate variables and NOT collection variables. (you can also create To, CC or BCC if needed and query them too). Make sure you specify "1" in Specify item limit field. 

    2. Using Send notification action configure appropriate fields using data from the above Query List and/or item properties.




This will reduce the current complexity in the workflow and if there are new choices or current choices are no longer needed then it's easily scalable.


 


 

Reply