Skip to main content

Hello!

   Total newbie here (just got a "crash course" in SharePoint/Nintex a day ago), so I apologize if I misspeak in terms of jargon and syntax.

 

I'm currently working on a project in trying to design a form that serves as a daily debriefing, with the goal of using the form's selections to populate an e-mail body.

 

In the form, I have some functions that would 'show' (aka unhide) certain options dependent on the choice.

 

For example:

Departments: Bakery, One-of-A-Kind-Gelato

Dessert Options: Cake, Croissants, Pies

Flavors: Chocolate, Strawberry, Vanilla

- If Bakery is selected, then the dessert options would manifest. If Cake option is selected, then the flavors options would appear as well.

 

Sample E-mails That Would Be Sent

Email #1

Department: Bakery

Dessert Option: Cake

Flavor: Chocolate

 

Email #2

Department: Gelato

Dessert Option: N/A

Flavor: N/A

 

- Ideally, I would like to create custom e-mails based on the choice selected (but that isn't feasible). Instead, perhaps an e-mail w/ each column listed, and if the column/option was not filled in/selected on the form, it'd populate with N/A. Is this best done on the workflow level, or the form level? I tried creating multiple branches for the workflow, and attempted to create variables and experiment with regex (replacing blanks w/ N/A), but to no avail. The resulting workflow also looked convoluted with multiple variables...

Thank you for any insight/directions!

 

Hello @vities, just add a switch action to the worklfow and check the value of Department Column. 



you should have 2 branch: Bakery & Gelato.



and each branch you add your notification action with the required body


Hi @vities 



Use variables.



Set the value of the variables and use the variables in the Email



 



 



If (Dessert Value == "Cake" )



    Set var txt_cake = "Cake"



Else



    Set var txt_cake = "-N/A-"





 


Then create a single Email and use the variables.



 



Email



Department: {Variable:txt_Bakery}



Dessert Option: {Variable:txt_Cake}



Flavor: {Variable:@txt_Flavor}



 


Thank you guys for taking the time to respond! I wish there was a way to accept both solutions!



I actually ended up using a medley of both @DimaHijazi 's switch solution for workflow and @Garrett variable designation.



 



I originally had the N/A set up as a reg expression:





 



Thank you guys once again 🙂


Reply