SharePoint Integration

Re: Info Path 2013 form not showing all data in a field

Hilary Stoupa — Wed, 02 Oct 2019 19:20:13 GMT

I think happy is the appropriate response - I didn't think about the data type as the issue. Good job and I'm glad you found it and fixed it!

Re: Info Path 2013 form not showing all data in a field

seryth — Wed, 02 Oct 2019 19:10:10 GMT

I don't know if I should be happy or if I should cry.

I was looking over everything again. The list open on one scree, Info Path on another, and SharePoint Designer open on the third. While looking at the MLT1History I decided to change the text type from Enhanced Rich Text to Rich text.

That solved the problem. I made the change, refreshed the fields in Info Path, removed and then replace the appropriate fields into the form, and published...

Why did I ever go into IT?

Re: Info Path 2013 form not showing all data in a field

Hilary Stoupa — Wed, 02 Oct 2019 17:44:54 GMT

The data is there, it just doesn't display. So, when you open and then submit a form that shows these symptoms, the data is still in the list. I have no idea. I mean, my suspicion would be that the workflow is actually changing the data, but if it still exists when you export the list to Excel, that's not it. I was hoping a different control type would show all the data..... I wonder if there is some special char in there that is causing the issue? I can't think of what it would be, but that may be something worth looking at. If it were a regular InfoPath form, we could look at the XML, but that's not possible with a list....You could try a REST query in the browser on the list, but I'd assume that is going to return the same thing as you see in Excel.

Re: Info Path 2013 form not showing all data in a field

seryth — Wed, 02 Oct 2019 11:30:09 GMT

No matter what changes I make or when I make the change the data is always in SharePoint. I can always see my data in Excel after the export or a refresh. Its the visibilty in Info Path that changes

Re: Info Path 2013 form not showing all data in a field

Hilary Stoupa — Tue, 01 Oct 2019 23:26:47 GMT

Yeah, I have literally no idea. If you save the form when you repro the issue (i.e., you didn't make changes in step 2 and the date time info is not displaying, but you can see the info is in the list via Excel) - does the data then go missing in the list? That is, if the data round-trips, does InfoPath cause you to lose the data?

Re: Info Path 2013 form not showing all data in a field

seryth — Tue, 01 Oct 2019 22:05:09 GMT

Hilary Stoupa:
So- what I'm suggesting is that you try adding a calculated value form control for these History fields, just on the off chance the form behaves differently. You can find the calculated value control on the ribbon and when you add it, you'll be prompted to enter an XPath - you can use the fx button to open the formula editor and select your field. Seems worth a try.

I gave this a try and no dice. It is mirroring the MLT1History. I am still losing the date/time/user stamp.

Re: Info Path 2013 form not showing all data in a field

seryth — Tue, 01 Oct 2019 21:56:00 GMT

I'm sorry. I totally misread that..... I will give it a try

Re: Info Path 2013 form not showing all data in a field

seryth — Tue, 01 Oct 2019 21:49:44 GMT

No. There is no calculated field in info path. The is history is created by a work flow.

If MLT1 is not blank

then

Set Variable to = date/time/user & MLT1 Text

Else set Variable to MLT1History

Then set MLT1History to Variable.

all info path is doing is showing the field.

Re: Info Path 2013 form not showing all data in a field

Hilary Stoupa — Tue, 01 Oct 2019 21:35:12 GMT

So- what I'm suggesting is that you try adding a calculated value form control for these History fields, just on the off chance the form behaves differently. You can find the calculated value control on the ribbon and when you add it, you'll be prompted to enter an XPath - you can use the fx button to open the formula editor and select your field. Seems worth a try.

Re: Info Path 2013 form not showing all data in a field

seryth — Tue, 01 Oct 2019 21:00:58 GMT

I would guess text boxes? Since the history field is just another field in my list I just added that field to my form from the field list.

Re: Info Path 2013 form not showing all data in a field

Hilary Stoupa — Tue, 01 Oct 2019 20:48:51 GMT

Any chance it is the workflow modifying these? I'd guess no, since you can export to Excel and see the values. Are you displaying the data from the History columns in calculated values in your form? Or in text boxes?

Re: Info Path 2013 form not showing all data in a field

seryth — Tue, 01 Oct 2019 20:34:53 GMT

Im sorry but I can not attach a copy of the form.

This is the tutorial that I followed.

https://jamilhaddadin.com/2011/12/03/implementing-workflow-using-infopath-2010-and-sharepoint-designer-2010/

I know it was for 2010, but the logic seemed to fit my business needs.

Re: Info Path 2013 form not showing all data in a field

Hilary Stoupa — Tue, 01 Oct 2019 20:25:58 GMT

Any chance I can just see a copy of the form? You can attach it under the Options tab in a reply.

Re: Info Path 2013 form not showing all data in a field

seryth — Tue, 01 Oct 2019 20:16:06 GMT

All of the data is coming from the same item. In my list there are about 20 different fields. Some are choice fields, some are dates, some are people or group fields. The only fields giving me issues are these multi-line text fields. Allow me describe how the tool works as you may find that relevant. I apologize now.... I have had a hell of a time figuring out how to explain this in a way that makes sense. Please note that each Multi-line text field has a corresponding history field. This history field is also a multi line text field.

I will start with Info Path. There are 4 form views (FV1-4). The form view that will load is based on a choice field labeled state. Each form view contains a set of buttons at the bottom. When creating a new item in the list the first FV1 will be displayed. This is because the State field is blank. It has 7 fields of data that need to be populated. A a few choice fields, one person or group (this is to assign the item to a person), and two multi line text fields (MLT1 and MLT2). When the user clicks the submit button at the bottom of the form Info Path performs several actions. 1) InfoPath will populate a field labeled Action. 2) The data will be send over the main data connection 3) the form will close with no prompt. Now The work flows kick in. One work flow triggers on new items. It simply copies the ID of the item to a new field so that I can reference it with a calculated field. Then the next work flow triggers and this one is more complex.

Stage 1 looks at the MLT1 field. If MLT1 is not blank then write the modified date/time, modified by, and the text in MLT1 to a workflow variable. If it is blank then write what is currently in MLT1History to the variable. Then update MLT1History with the workflow variable. Next is Stage 2. Stage two looks at that info path populated into the action field. If Action = X then send and email, set state to 1 and then clear the action field.

The person who received the email will go into the list. They will be greeted with FV2. When FV2 loads everything works fine. My MLT1History and MLT2History each show a date/time/user stamp and the text that was entered. On this stage a person will enter data into MLT3 and and select a date in a date field. When they click the submit button Info Path will set the action to Y, submit data over the main data connection and closes the form with no prompt. Repeat the work flows.

The person who created the item will return to it to review what was added. They are greeted with FV3. This is where the date/time/user stamp is removed as I outlined in my initial post. As I stated in my initial post if something was entered in FV2 (which will be highly unlikely) then all works fine.

I hope that paints a clearer picture of the process and how different things are populated.

Re: Info Path 2013 form not showing all data in a field

Hilary Stoupa — Tue, 01 Oct 2019 15:23:47 GMT

Ok, so this is a list form and the data is in the same list for the same item - is that correct? Does whether or not the data shows depend on the type of control? Have you tried text box vs. calculated value?