InfoPath Dev

I've tried to resolve the following for two weeks; being ignorant to the ways of workflow, I've had no success. I've created a workflow email that returns 17 lines of data, based on entries in an InfoPath form. The first 7 lines will always have data, and should always appear in the email; the other 10 lines may or may not have data. I've not been successful in creating a variable that will look at the pre-determined form fields for text (lines 8 - 17), and either display or eliminate these fields from the email based on the presence or lack of text. Suggestions? Examples? Video link?

It would be helpful to better understand what you mean by "lines of data" - are these individual promoted fields in the library? Each field determines a "line" and (for the optional items) whether the line appears?

I just tried this and am attaching a screenshot I hope will help you. I created variables and for each one, checked to see if a field had a value prior to setting the variable to the value from the library. Then I created my email using the variables. In the sent emails (samples also in screenshot) if the variables were blank, they simply didn't take up a line in the email. It is pretty straightforward. Hopefully this helps.

In my first attempted I uploaded a form, leaving lines 8 - 10 (the three Def No 1 lines), empty. Each possible deficiency has three lines (No., Question, Comment). To your earlier question, yes, each line represents and manually created label and a promoted field.

I created the following variables, based on your example: 

 

I got the following email. The email still included all 10 deficiency comment groups, plus the No. 1 'blank' Deficiency Question; which, to this point -  without the variable, didn't appear when blank - as can be seen with the only deficiency groups.

My goal is to have all blank fields or their labels NOT appear in the email.

A New REDW Employee Housing Annual Fire and Life Safety Inspection Report has been Uploaded -

Park: REDW
Site Name: (P228) Redwood National Park
Location ID: 11131
Location Description: Wolf Creek House / Lower, 5353
Occupancy Type: Storage
Tenant: NPS
Inspector's Name: Curtis T
Inspection Date: 12/12/2016 12:00:00 AM
NPS Representative's Name: Curtis T
Inspection Results: No Deficiencies Noted During Inspection.
Deficiency No.: 
Deficiency Question: 
Deficiency Description: 
Deficiency No.: 
Deficiency Description: 
Deficiency No.: 
Deficiency Description: 
Deficiency No.: 
Deficiency Description: 
Deficiency No.: 
Deficiency Description: 
Deficiency No.: 
Deficiency Description: 
Deficiency No.: 
Deficiency Description: 
Deficiency No.: 
Deficiency Description: 
Deficiency No.: 
Deficiency Description: 
Deficiency No.: 
Deficiency Description:

 

 

    then Email (my email here)

 

 

 

 

 The image didn't appear in the last post. I've attached the variable and the email structure here.

Use your formula to set the variable to the label & the field value. If you need to use two variables for each line so that your label can be bold, do that. I see you creating variables - I don't see you using them in your email. So - if q1 is not blank, set a variable for the label, and set a variable for the value. Use the variables in your email - they will be null if the condition isn't met.

 Manna just fell from the heavens; I realized the 'labels' were appearing - when the fields were blank - because I artificially created the labels within the workflow email. That works for the first 7 lines, because they will always have data. The rest of the email should only include the 'lookups', and where they are blank they will not appear!

Yup, you got it. :)