Field with Value using concat

[David_in_MCO]

I am trying to generate an email workflow in SharePoint from data collected
in a browser enabled InfoPath form. In order to present the text I want in
the email, I am setting up an InfoPath rule to set a a Value of a field using
the concat formula, and inserting multiple fields from the form. I am using
concat, so that I can collect data from 7 different fields (in many instances
the collected fields are blank) and combine them into a single source field
that can be used in the body of the email for the workflow.
This seems to be working fine (rules are all working as expected), but the
data from this concat is showing up in the email as 5 question marks
("?????"), no matter what is in the 7 fields being concatinated.
Not sure if this is an InfoPath problem, or SharePoint.

 

[SMS]

I am trying to generate an email workflow in SharePoint from data collected
in a browser enabled InfoPath form. In order to present the text I want in
the email, I am setting up an InfoPath rule to set a a Value of a field using
the concat formula, and inserting multiple fields from the form. I am using
concat, so that I can collect data from 7 different fields (in many instances
the collected fields are blank) and combine them into a single source field
that can be used in the body of the email for the workflow.
This seems to be working fine (rules are all working as expected), but the
data from this concat is showing up in the email as 5 question marks
("?????"), no matter what is in the 7 fields being concatinated.
Not sure if this is an InfoPath problem, or SharePoint.

Another way you can do it is to publish all the 7 fields and bring it
together in the email

 

[David_in_MCO]

Another way you can do it is to publish all the 7 fields and bring it
together in the email

I have promoted each field, and republished to sharepoint. I have modified
the workflow using Designer, and selected the fields in the body lookup.
Same results. Each line where a field is a lookup returns 5 question marks.

 

[David_in_MCO]

I have promoted each field, and republished to sharepoint. I have modified
the workflow using Designer, and selected the fields in the body lookup.
Same results. Each line where a field is a lookup returns 5 question marks.
UPDATE: Where an entry has been made in the fields I promoted, the data can
be seen (text). Where no entry was made, the results displayed are the
question marks....

 

[SMS]

I have promoted each field, and republished to sharepoint. I have modified
the workflow using Designer, and selected the fields in the body lookup.
Same results. Each line where a field is a lookup returns 5 question marks.
UPDATE: Where an entry has been made in the fields I promoted, the data can
be seen (text). Where no entry was made, the results displayed are the
question marks....

What is the control type your using for the fields in Infopath?

 

[David S (Orlando)]

What is the control type your using for the fields in Infopath?

I am using Text Box.

Here is a real quick brief on my goal:
I created a form for our techs to use on our sharepoint server. The form
list several items that need to be looked at. Along side of each item is a
single check box (selected if the item is functioning correctly) and a text
box (for them to enter comments about the item) { Data type: Text (string) }
A comment is required if the box is not checked. I have rules on the Submit
button for this logic.

My goal is to be able to generate an email, where the body only list the
comments entered for the items not working. (I am using a lookup of the
promoted text boxes)
(I was originally trying to use a rule, based on the status of the checkbox,
to set a fields value using a funciton with concat and inserting the value
from each of the text box fields)

I have some later objectives to be able to report and track the items that
were not checked (trending analysis, etc.) so I am sure I will have more
questions about that down the road...

 

[SMS]

I am using Text Box.

Here is a real quick brief on my goal:
I created a form for our techs to use on our sharepoint server. The form
list several items that need to be looked at. Along side of each item is a
single check box (selected if the item is functioning correctly) and a text
box (for them to enter comments about the item) { Data type: Text (string) }
A comment is required if the box is not checked. I have rules on the Submit
button for this logic.

My goal is to be able to generate an email, where the body only list the
comments entered for the items not working. (I am using a lookup of the
promoted text boxes)
(I was originally trying to use a rule, based on the status of the checkbox,
to set a fields value using a funciton with concat and inserting the value
from each of the text box fields)

I have some later objectives to be able to report and track the items that
were not checked (trending analysis, etc.) so I am sure I will have more
questions about that  down the road...

I am not sure what the problem is.

Which version of Infopath and SharePoint do you have?