I'm trying to update field in a recurring section using update xml but when I tried to update form data column using result xml, my forms errors out and cannot open it.
Any suggestions?
I've attached the workflow for reference.
Thanks.
Hello,
I'll admit I didn't download the workflow, but want to know what type of field you are attempting to update? If you are updating a Lookup field for example it might be that you are entering the wrong type of data when it is expecting an ID for example that would cause it to error out. Does the change in the XML take place (have you looked at the column after you run the action) or does it error out before it even has any effect?
Thanks
Mike
as I first step I'd suggest to store repeating section's data in it's own list field.
FormData hidden field holds other needed data, not only repeating section's one, in a specific XML structure. you seem to update FormData with just repeater data, which breaks it structure and may cause errors you experience.
so create a multiline plain text list field and connect repeating section control to this field.
update the workflow to work on this field.
this way you should see directly in list view what's the content of repeter's XML and see whether update performed was correct or not.
+12
I'm using Nintex form which has repeating sections. Nintex forms don't allow to connect fields in repeating section to a SharePoint column so I cannot display values on the form.
I'm trying to achieve below things:
1. For each row in my repeating section, create corresponding items in a new SP list
2. Get ID of the item which was created in the new SP list
3. Update that in one of the field in repeating section
Below are fields I've in repeating section:
1. Task Title - Single line text
2. Due Date - Date & Time
3. Assigned To - Person or Group
4. ID # - Single line text
Yes, I'm aware that my form data will have other information too, but I need a way to update that form data using my new XML. I've also checked that my update xml action is giving me the xml I need, just need a way to insert that into form data.
I would like to avoid creating a multi-line text in the SP list for form data because I don't want my end users to make any changes to that data. If there is an alternate solution then it will be my first choice.
Thanks,
Kunal
Nintex forms don't allow to connect fields in repeating section to a SharePoint column
that's for sure. I meant to connect (whole) repeating section control to a multiline plain text field.
I've also checked that my update xml action is giving me the xml I need, just need a way to insert that into form data.
I'm not able to provide exact example how you should do it since I do not know your exact FormData structure and do not know what exactly you have copied out of it into workflow XML variable.
but basically what you need to do is
- copy whole FormData content to a workflow variable
- configure Update XML action as follows
- as a XML source use above populated workflow variable
- with XPath expression address the node in FormData XML that holds repeater data resp. that you want to update. very likely it will be just the same XPath as you used to read out the repeater data at the beginning.
typically it might have been "//RepeaterData" - since the variable you're going to make update with already contains a XML, make sure to select 'replace node content' action
- configure a variable to make an update with
- configure a target variable to store result to
- update FormData list field with a value of above result variable
I don't want my end users to make any changes to that data
you need not to present the field to the users.
if you disable quick edit, users will not be able to able to do side updates at all
If there is an alternate solution then it will be my first choice.
as you like 
from my experience it's much more practical and convenient to have repeater data stored in dedicated list field.
not only due to easier work with pure repeater data (possible direct list field updates) but as well when you need to troubleshoot problems or you need to make forced (admin) updates of repeater data (eg. if workflow fails)
+12
I tried to perform below steps but somehow when I update form data, the form doesn't open and gives correlation error (something about deserializing the object of type System.Collections.Generic.List`1[[Nintex.Forms.FormVariable, Nintex.Forms.....). Steps I did were:
- Get Form data from current item
- Store that in a variable
- Get Repeating Section UDA - This to get the total # of rows in my repeating section and also to get XML for that repeating section (I can use Query XML and use Form Data to get the XML of my repeating section but, I couldn't figure it out a way to get how many rows are there in it. I need # of rows to run loop to create an item).
- Set Index as 1
- Run loop if index is less than or equal to # of rows
- Query XML - Source is Repeating Section's XML and getting all 4 fields' value
- Create Item in another list (storing ID of list item which got created in a variable)
- Converting above ID to string since in repeating section it's string value
- Update my Repeating Section XML with this ID using Update XML action
- Increase index by 1
- After the loop is over, I'm updating my form data XML using step 5(d) data (I'm selecting replace node contents)
- Now using updated form data xml, I'm updating the current item
- Workflow gets completed without any issue, but when I try to open the form, it gives me above correlation error.
FYI...I even tried to encode XML code I'm getting in step 5(d), but same result.
I'm sending you files for reference in separate message.
roughly your procedure seems to be correct. likely there is just a misconfiguration in one of actions.
try to send to yourself as a plaintext notification content of FormData field after the step 2, and value to be updated with after the step 6. compare them and check whether structure did not get broken.
I don't see any files attached, but better would be if you posted screenshots of your configuration.
I couldn't figure it out a way to get how many rows are there in it
you usually do not need to know number of rows in repeating section.
once you query a column from repeating section into a collection variable you can iterate over the collection with for each loop action. it will take care to run once for each collection element.
note as well that for each loop action is faster then 'regular' loop action
+12
I was going to send those files which I emailed to myself but it seems I can only upload images.
Below are my XML codes.....also there are two entry in each code which is a people group, I've added a dummy entry and made it bold. Look for abckp and abc j.
I don't have any problem with the workflow as it's finishing without any issues. Also when I check the modified code, it looks it's doing what I want BUT when I try to update old form data with new form data, issue starts and I can't open the form again.
Original Form Data XML:
<?xml version="1.0" encoding="utf-8"?><FormVariables><Version /><ReportedDate type="System.DateTime">04/13/2018 00:00:00</ReportedDate><_x0039_70841e1-1ccb-4d27-8baf-c5add2b21d31 type="System.String"></_x0039_70841e1-1ccb-4d27-8baf-c5add2b21d31><_x0038_2e9067b-eb80-41b2-8749-6731cae0ed55 type="System.String"></_x0038_2e9067b-eb80-41b2-8749-6731cae0ed55><IncidentHours type="System.String">09</IncidentHours><IncidentMinutes type="System.String">53</IncidentMinutes><ReportedHours type="System.String">09</ReportedHours><ReportedMinutes type="System.String">53</ReportedMinutes><InvestigationTeamLeadLastName type="System.String"></InvestigationTeamLeadLastName><_x0036_cc0fab4-d4d5-4c2d-864f-30a56929690f type="System.String"></_x0036_cc0fab4-d4d5-4c2d-864f-30a56929690f><e15c2131-7632-4a87-a0b1-599ef3e0dc60 type="System.String"></e15c2131-7632-4a87-a0b1-599ef3e0dc60><e6ee3f8d-8d20-4546-84ae-91365d05dbc6 type="System.String"></e6ee3f8d-8d20-4546-84ae-91365d05dbc6><_x0035_98ea785-f97b-4bb9-8700-94af8023aedc type="System.String"></_x0035_98ea785-f97b-4bb9-8700-94af8023aedc><d8f58c2c-571b-4ca1-95ec-5636cf36eab4 type="System.String"></d8f58c2c-571b-4ca1-95ec-5636cf36eab4><_x0031_80817f4-d4f9-4e80-aa18-d45fe5fddfb2 type="System.String"></_x0031_80817f4-d4f9-4e80-aa18-d45fe5fddfb2><_x0031_e0e5af5-6756-47f5-86e4-6c210b4473cf type="System.String"></_x0031_e0e5af5-6756-47f5-86e4-6c210b4473cf><_x0037_ca54afc-1b81-4726-8f9a-39d4fffce5ea type="System.String"></_x0037_ca54afc-1b81-4726-8f9a-39d4fffce5ea><_x0035_b811c67-68b7-4ebc-99b6-7405e82ca62c type="System.String"></_x0035_b811c67-68b7-4ebc-99b6-7405e82ca62c><f6073a85-5c84-4b9c-912d-4689c5d39326 type="System.String"></f6073a85-5c84-4b9c-912d-4689c5d39326><ddbc6c72-9751-4ec3-b6e6-d0f1743a5424 type="System.String"></ddbc6c72-9751-4ec3-b6e6-d0f1743a5424><_x0039_d88cc01-ddb5-41a9-bef8-f1c4cdb8f36f type="System.String"></_x0039_d88cc01-ddb5-41a9-bef8-f1c4cdb8f36f><_x0034_4c525dc-a5b7-4ae2-a182-00fcde301f81 type="System.String"></_x0034_4c525dc-a5b7-4ae2-a182-00fcde301f81><_x0032_29cc80e-6d8b-4a70-a1db-9a6698c00e31 type="System.String"></_x0032_29cc80e-6d8b-4a70-a1db-9a6698c00e31><bbfc2841-35bc-4db2-b065-5214a9b54233 type="System.String"></bbfc2841-35bc-4db2-b065-5214a9b54233><_x0038_67a5f32-8eab-4a4a-a8af-6a911df3cf23 type="System.String"></_x0038_67a5f32-8eab-4a4a-a8af-6a911df3cf23><IncidentDate type="System.DateTime">04/13/2018 00:00:00</IncidentDate><InvestigationTeamLeadFirstName type="System.String"></InvestigationTeamLeadFirstName><_x0034_18b44a6-533e-454d-b7c5-2074b19d2fc7 type="System.String">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;RepeaterData&gt;&lt;Version /&gt;&lt;Items&gt;&lt;Item&gt;&lt;InvestigationTeamMemberLastName type=&quot;System.String&quot;&gt;&lt;/InvestigationTeamMemberLastName&gt;&lt;InvestigationTeamMemberLastName type=&quot;System.String&quot;&gt;&lt;/InvestigationTeamMemberLastName&gt;&lt;InvestigativeTeamMembersPosition type=&quot;System.String&quot;&gt;&lt;/InvestigativeTeamMembersPosition&gt;&lt;InvestigativeTeamMembersCompany type=&quot;System.String&quot;&gt;&lt;/InvestigativeTeamMembersCompany&gt;&lt;InvestigativeTeamMembersWPCMember type=&quot;System.Boolean&quot;&gt;False&lt;/InvestigativeTeamMembersWPCMember&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RepeaterData&gt;</_x0034_18b44a6-533e-454d-b7c5-2074b19d2fc7><_x0036_9cb4868-0ffe-4beb-9e13-e579f28579a4 type="System.String">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;RepeaterData&gt;&lt;Version /&gt;&lt;Items&gt;&lt;Item&gt;&lt;OtherSignificantContributingCasualFactor type=&quot;System.String&quot;&gt;&lt;/OtherSignificantContributingCasualFactor&gt;&lt;OtherSignificantContributingCasualFactorExplanation type=&quot;System.String&quot;&gt;&lt;/OtherSignificantContributingCasualFactorExplanation&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RepeaterData&gt;</_x0036_9cb4868-0ffe-4beb-9e13-e579f28579a4><e98fe627-52b7-4730-9882-c41e08677c7b type="System.String">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;RepeaterData&gt;&lt;Version /&gt;&lt;Items&gt;&lt;Item&gt;&lt;d26cd9ee-212f-491d-9d13-a1c810fcfa4e type=&quot;System.String&quot;&gt;&lt;/d26cd9ee-212f-491d-9d13-a1c810fcfa4e&gt;&lt;_x0032_94476fd-4b00-46cf-9269-30d56b991daf type=&quot;System.String&quot;&gt;&lt;/_x0032_94476fd-4b00-46cf-9269-30d56b991daf&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RepeaterData&gt;</e98fe627-52b7-4730-9882-c41e08677c7b><RepSec_CorrectiveActions type="System.String">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;RepeaterData&gt;&lt;Version /&gt;&lt;Items&gt;&lt;Item&gt;&lt;Rep_CorrectiveAction type=&quot;System.String&quot;&gt;Test CA 01&lt;/Rep_CorrectiveAction&gt;&lt;Rep_ResponsiblePerson type=&quot;System.String&quot;&gt;i:0#.w|abckp&lt;/Rep_ResponsiblePerson&gt;&lt;Rep_DueDate type=&quot;System.DateTime&quot;&gt;05/04/2018 00:00:00&lt;/Rep_DueDate&gt;&lt;Rep_HCAI_IDNo type=&quot;System.String&quot;&gt;&lt;/Rep_HCAI_IDNo&gt;&lt;/Item&gt;&lt;Item&gt;&lt;Rep_CorrectiveAction type=&quot;System.String&quot;&gt;Test CA 02&lt;/Rep_CorrectiveAction&gt;&lt;Rep_ResponsiblePerson type=&quot;System.String&quot;&gt;i:0#.w|abc j&lt;/Rep_ResponsiblePerson&gt;&lt;Rep_DueDate type=&quot;System.DateTime&quot;&gt;05/05/2018 00:00:00&lt;/Rep_DueDate&gt;&lt;Rep_HCAI_IDNo type=&quot;System.String&quot;&gt;&lt;/Rep_HCAI_IDNo&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RepeaterData&gt;</RepSec_CorrectiveActions><Attachments_x0020_1 type="System.String"></Attachments_x0020_1></FormVariables>
***************************************************************************************************
Original Repeating Section XML:
<?xml version="1.0" encoding="utf-8"?><RepeaterData><Version /><Items><Item><Rep_CorrectiveAction type="System.String">Test CA 01</Rep_CorrectiveAction><Rep_ResponsiblePerson type="System.String">i:0#.w|abckp</Rep_ResponsiblePerson><Rep_DueDate type="System.DateTime">05/04/2018 00:00:00</Rep_DueDate><Rep_HCAI_IDNo type="System.String"></Rep_HCAI_IDNo></Item><Item><Rep_CorrectiveAction type="System.String">Test CA 02</Rep_CorrectiveAction><Rep_ResponsiblePerson type="System.String">i:0#.w|abc j</Rep_ResponsiblePerson><Rep_DueDate type="System.DateTime">05/05/2018 00:00:00</Rep_DueDate><Rep_HCAI_IDNo type="System.String"></Rep_HCAI_IDNo></Item></Items></RepeaterData>
***************************************************************************************************
Modified Repeating Section XML:
<?xml version="1.0" encoding="utf-8"?><RepeaterData><Version /><Items><Item><Rep_CorrectiveAction type="System.String">Test CA 01</Rep_CorrectiveAction><Rep_ResponsiblePerson type="System.String">i:0#.w|abckp</Rep_ResponsiblePerson><Rep_DueDate type="System.DateTime">05/04/2018 00:00:00</Rep_DueDate><Rep_HCAI_IDNo type="System.String">83</Rep_HCAI_IDNo></Item><Item><Rep_CorrectiveAction type="System.String">Test CA 02</Rep_CorrectiveAction><Rep_ResponsiblePerson type="System.String">i:0#.w|abc j</Rep_ResponsiblePerson><Rep_DueDate type="System.DateTime">05/05/2018 00:00:00</Rep_DueDate><Rep_HCAI_IDNo type="System.String">84</Rep_HCAI_IDNo></Item></Items></RepeaterData>
***************************************************************************************************
Modified Form Data XML (after using Update XML and inserting above modified repeating section code in Form Data XML):
<?xml version="1.0" encoding="utf-8"?><FormVariables><Version /><ReportedDate type="System.DateTime">04/13/2018 00:00:00</ReportedDate><_x0039_70841e1-1ccb-4d27-8baf-c5add2b21d31 type="System.String"></_x0039_70841e1-1ccb-4d27-8baf-c5add2b21d31><_x0038_2e9067b-eb80-41b2-8749-6731cae0ed55 type="System.String"></_x0038_2e9067b-eb80-41b2-8749-6731cae0ed55><IncidentHours type="System.String">09</IncidentHours><IncidentMinutes type="System.String">53</IncidentMinutes><ReportedHours type="System.String">09</ReportedHours><ReportedMinutes type="System.String">53</ReportedMinutes><InvestigationTeamLeadLastName type="System.String"></InvestigationTeamLeadLastName><_x0036_cc0fab4-d4d5-4c2d-864f-30a56929690f type="System.String"></_x0036_cc0fab4-d4d5-4c2d-864f-30a56929690f><e15c2131-7632-4a87-a0b1-599ef3e0dc60 type="System.String"></e15c2131-7632-4a87-a0b1-599ef3e0dc60><e6ee3f8d-8d20-4546-84ae-91365d05dbc6 type="System.String"></e6ee3f8d-8d20-4546-84ae-91365d05dbc6><_x0035_98ea785-f97b-4bb9-8700-94af8023aedc type="System.String"></_x0035_98ea785-f97b-4bb9-8700-94af8023aedc><d8f58c2c-571b-4ca1-95ec-5636cf36eab4 type="System.String"></d8f58c2c-571b-4ca1-95ec-5636cf36eab4><_x0031_80817f4-d4f9-4e80-aa18-d45fe5fddfb2 type="System.String"></_x0031_80817f4-d4f9-4e80-aa18-d45fe5fddfb2><_x0031_e0e5af5-6756-47f5-86e4-6c210b4473cf type="System.String"></_x0031_e0e5af5-6756-47f5-86e4-6c210b4473cf><_x0037_ca54afc-1b81-4726-8f9a-39d4fffce5ea type="System.String"></_x0037_ca54afc-1b81-4726-8f9a-39d4fffce5ea><_x0035_b811c67-68b7-4ebc-99b6-7405e82ca62c type="System.String"></_x0035_b811c67-68b7-4ebc-99b6-7405e82ca62c><f6073a85-5c84-4b9c-912d-4689c5d39326 type="System.String"></f6073a85-5c84-4b9c-912d-4689c5d39326><ddbc6c72-9751-4ec3-b6e6-d0f1743a5424 type="System.String"></ddbc6c72-9751-4ec3-b6e6-d0f1743a5424><_x0039_d88cc01-ddb5-41a9-bef8-f1c4cdb8f36f type="System.String"></_x0039_d88cc01-ddb5-41a9-bef8-f1c4cdb8f36f><_x0034_4c525dc-a5b7-4ae2-a182-00fcde301f81 type="System.String"></_x0034_4c525dc-a5b7-4ae2-a182-00fcde301f81><_x0032_29cc80e-6d8b-4a70-a1db-9a6698c00e31 type="System.String"></_x0032_29cc80e-6d8b-4a70-a1db-9a6698c00e31><bbfc2841-35bc-4db2-b065-5214a9b54233 type="System.String"></bbfc2841-35bc-4db2-b065-5214a9b54233><_x0038_67a5f32-8eab-4a4a-a8af-6a911df3cf23 type="System.String"></_x0038_67a5f32-8eab-4a4a-a8af-6a911df3cf23><IncidentDate type="System.DateTime">04/13/2018 00:00:00</IncidentDate><InvestigationTeamLeadFirstName type="System.String"></InvestigationTeamLeadFirstName><_x0034_18b44a6-533e-454d-b7c5-2074b19d2fc7 type="System.String">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;RepeaterData&gt;&lt;Version /&gt;&lt;Items&gt;&lt;Item&gt;&lt;InvestigationTeamMemberLastName type=&quot;System.String&quot;&gt;&lt;/InvestigationTeamMemberLastName&gt;&lt;InvestigationTeamMemberLastName type=&quot;System.String&quot;&gt;&lt;/InvestigationTeamMemberLastName&gt;&lt;InvestigativeTeamMembersPosition type=&quot;System.String&quot;&gt;&lt;/InvestigativeTeamMembersPosition&gt;&lt;InvestigativeTeamMembersCompany type=&quot;System.String&quot;&gt;&lt;/InvestigativeTeamMembersCompany&gt;&lt;InvestigativeTeamMembersWPCMember type=&quot;System.Boolean&quot;&gt;False&lt;/InvestigativeTeamMembersWPCMember&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RepeaterData&gt;</_x0034_18b44a6-533e-454d-b7c5-2074b19d2fc7><_x0036_9cb4868-0ffe-4beb-9e13-e579f28579a4 type="System.String">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;RepeaterData&gt;&lt;Version /&gt;&lt;Items&gt;&lt;Item&gt;&lt;OtherSignificantContributingCasualFactor type=&quot;System.String&quot;&gt;&lt;/OtherSignificantContributingCasualFactor&gt;&lt;OtherSignificantContributingCasualFactorExplanation type=&quot;System.String&quot;&gt;&lt;/OtherSignificantContributingCasualFactorExplanation&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RepeaterData&gt;</_x0036_9cb4868-0ffe-4beb-9e13-e579f28579a4><e98fe627-52b7-4730-9882-c41e08677c7b type="System.String">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;RepeaterData&gt;&lt;Version /&gt;&lt;Items&gt;&lt;Item&gt;&lt;d26cd9ee-212f-491d-9d13-a1c810fcfa4e type=&quot;System.String&quot;&gt;&lt;/d26cd9ee-212f-491d-9d13-a1c810fcfa4e&gt;&lt;_x0032_94476fd-4b00-46cf-9269-30d56b991daf type=&quot;System.String&quot;&gt;&lt;/_x0032_94476fd-4b00-46cf-9269-30d56b991daf&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RepeaterData&gt;</e98fe627-52b7-4730-9882-c41e08677c7b><RepSec_CorrectiveActions type="System.String"><?xml version="1.0" encoding="utf-8"?><RepeaterData><Version /><Items><Item><Rep_CorrectiveAction type="System.String">Test CA 01</Rep_CorrectiveAction><Rep_ResponsiblePerson type="System.String">i:0#.w|abckp</Rep_ResponsiblePerson><Rep_DueDate type="System.DateTime">05/04/2018 00:00:00</Rep_DueDate><Rep_HCAI_IDNo type="System.String">83</Rep_HCAI_IDNo></Item><Item><Rep_CorrectiveAction type="System.String">Test CA 02</Rep_CorrectiveAction><Rep_ResponsiblePerson type="System.String">i:0#.w|abc j</Rep_ResponsiblePerson><Rep_DueDate type="System.DateTime">05/05/2018 00:00:00</Rep_DueDate><Rep_HCAI_IDNo type="System.String">84</Rep_HCAI_IDNo></Item></Items></RepeaterData></RepSec_CorrectiveActions><Attachments_x0020_1 type="System.String"></Attachments_x0020_1></FormVariables>
***************************************************************************************************
have you compared the two XMLs?
if you have, you would immediately spot the difference - you have to XMLEncode() repeater XML snippet
+12
Even with the encode XML function, it's still the same issue.
Original Form Data XML:
<?xml version="1.0" encoding="utf-8"?><FormVariables><Version /><ReportedDate type="System.DateTime">04/18/2018 00:00:00</ReportedDate><_x0039_70841e1-1ccb-4d27-8baf-c5add2b21d31 type="System.String"></_x0039_70841e1-1ccb-4d27-8baf-c5add2b21d31><_x0038_2e9067b-eb80-41b2-8749-6731cae0ed55 type="System.String"></_x0038_2e9067b-eb80-41b2-8749-6731cae0ed55><IncidentHours type="System.String">14</IncidentHours><IncidentMinutes type="System.String">29</IncidentMinutes><ReportedHours type="System.String">14</ReportedHours><ReportedMinutes type="System.String">29</ReportedMinutes><InvestigationTeamLeadLastName type="System.String"></InvestigationTeamLeadLastName><_x0036_cc0fab4-d4d5-4c2d-864f-30a56929690f type="System.String"></_x0036_cc0fab4-d4d5-4c2d-864f-30a56929690f><e15c2131-7632-4a87-a0b1-599ef3e0dc60 type="System.String"></e15c2131-7632-4a87-a0b1-599ef3e0dc60><e6ee3f8d-8d20-4546-84ae-91365d05dbc6 type="System.String"></e6ee3f8d-8d20-4546-84ae-91365d05dbc6><_x0035_98ea785-f97b-4bb9-8700-94af8023aedc type="System.String"></_x0035_98ea785-f97b-4bb9-8700-94af8023aedc><d8f58c2c-571b-4ca1-95ec-5636cf36eab4 type="System.String"></d8f58c2c-571b-4ca1-95ec-5636cf36eab4><_x0031_80817f4-d4f9-4e80-aa18-d45fe5fddfb2 type="System.String"></_x0031_80817f4-d4f9-4e80-aa18-d45fe5fddfb2><_x0031_e0e5af5-6756-47f5-86e4-6c210b4473cf type="System.String"></_x0031_e0e5af5-6756-47f5-86e4-6c210b4473cf><_x0037_ca54afc-1b81-4726-8f9a-39d4fffce5ea type="System.String"></_x0037_ca54afc-1b81-4726-8f9a-39d4fffce5ea><_x0035_b811c67-68b7-4ebc-99b6-7405e82ca62c type="System.String"></_x0035_b811c67-68b7-4ebc-99b6-7405e82ca62c><f6073a85-5c84-4b9c-912d-4689c5d39326 type="System.String"></f6073a85-5c84-4b9c-912d-4689c5d39326><ddbc6c72-9751-4ec3-b6e6-d0f1743a5424 type="System.String"></ddbc6c72-9751-4ec3-b6e6-d0f1743a5424><_x0039_d88cc01-ddb5-41a9-bef8-f1c4cdb8f36f type="System.String"></_x0039_d88cc01-ddb5-41a9-bef8-f1c4cdb8f36f><_x0034_4c525dc-a5b7-4ae2-a182-00fcde301f81 type="System.String"></_x0034_4c525dc-a5b7-4ae2-a182-00fcde301f81><_x0032_29cc80e-6d8b-4a70-a1db-9a6698c00e31 type="System.String"></_x0032_29cc80e-6d8b-4a70-a1db-9a6698c00e31><bbfc2841-35bc-4db2-b065-5214a9b54233 type="System.String"></bbfc2841-35bc-4db2-b065-5214a9b54233><_x0038_67a5f32-8eab-4a4a-a8af-6a911df3cf23 type="System.String"></_x0038_67a5f32-8eab-4a4a-a8af-6a911df3cf23><IncidentDate type="System.DateTime">04/18/2018 00:00:00</IncidentDate><InvestigationTeamLeadFirstName type="System.String"></InvestigationTeamLeadFirstName><_x0034_18b44a6-533e-454d-b7c5-2074b19d2fc7 type="System.String">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;RepeaterData&gt;&lt;Version /&gt;&lt;Items&gt;&lt;Item&gt;&lt;InvestigationTeamMemberLastName type=&quot;System.String&quot;&gt;&lt;/InvestigationTeamMemberLastName&gt;&lt;InvestigationTeamMemberLastName type=&quot;System.String&quot;&gt;&lt;/InvestigationTeamMemberLastName&gt;&lt;InvestigativeTeamMembersPosition type=&quot;System.String&quot;&gt;&lt;/InvestigativeTeamMembersPosition&gt;&lt;InvestigativeTeamMembersCompany type=&quot;System.String&quot;&gt;&lt;/InvestigativeTeamMembersCompany&gt;&lt;InvestigativeTeamMembersWPCMember type=&quot;System.Boolean&quot;&gt;False&lt;/InvestigativeTeamMembersWPCMember&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RepeaterData&gt;</_x0034_18b44a6-533e-454d-b7c5-2074b19d2fc7><_x0036_9cb4868-0ffe-4beb-9e13-e579f28579a4 type="System.String">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;RepeaterData&gt;&lt;Version /&gt;&lt;Items&gt;&lt;Item&gt;&lt;OtherSignificantContributingCasualFactor type=&quot;System.String&quot;&gt;&lt;/OtherSignificantContributingCasualFactor&gt;&lt;OtherSignificantContributingCasualFactorExplanation type=&quot;System.String&quot;&gt;&lt;/OtherSignificantContributingCasualFactorExplanation&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RepeaterData&gt;</_x0036_9cb4868-0ffe-4beb-9e13-e579f28579a4><e98fe627-52b7-4730-9882-c41e08677c7b type="System.String">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;RepeaterData&gt;&lt;Version /&gt;&lt;Items&gt;&lt;Item&gt;&lt;d26cd9ee-212f-491d-9d13-a1c810fcfa4e type=&quot;System.String&quot;&gt;&lt;/d26cd9ee-212f-491d-9d13-a1c810fcfa4e&gt;&lt;_x0032_94476fd-4b00-46cf-9269-30d56b991daf type=&quot;System.String&quot;&gt;&lt;/_x0032_94476fd-4b00-46cf-9269-30d56b991daf&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RepeaterData&gt;</e98fe627-52b7-4730-9882-c41e08677c7b><RepSec_CorrectiveActions type="System.String">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;RepeaterData&gt;&lt;Version /&gt;&lt;Items&gt;&lt;Item&gt;&lt;Rep_CorrectiveAction type=&quot;System.String&quot;&gt;CA 1&lt;/Rep_CorrectiveAction&gt;&lt;Rep_ResponsiblePerson type=&quot;System.String&quot;&gt;i:0#.w|abckp&lt;/Rep_ResponsiblePerson&gt;&lt;Rep_DueDate type=&quot;System.DateTime&quot;&gt;05/03/2018 00:00:00&lt;/Rep_DueDate&gt;&lt;Rep_HCAI_IDNo type=&quot;System.String&quot;&gt;&lt;/Rep_HCAI_IDNo&gt;&lt;/Item&gt;&lt;Item&gt;&lt;Rep_CorrectiveAction type=&quot;System.String&quot;&gt;CA 2&lt;/Rep_CorrectiveAction&gt;&lt;Rep_ResponsiblePerson type=&quot;System.String&quot;&gt;i:0#.w|abc j&lt;/Rep_ResponsiblePerson&gt;&lt;Rep_DueDate type=&quot;System.DateTime&quot;&gt;04/21/2018 00:00:00&lt;/Rep_DueDate&gt;&lt;Rep_HCAI_IDNo type=&quot;System.String&quot;&gt;&lt;/Rep_HCAI_IDNo&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RepeaterData&gt;</RepSec_CorrectiveActions><Attachments_x0020_1 type="System.String"></Attachments_x0020_1></FormVariables>
***************************************************************************************
Modified Form Data XML after encoding repeating section XML:
<?xml version="1.0" encoding="utf-8"?><FormVariables><Version /><ReportedDate type="System.DateTime">04/18/2018 00:00:00</ReportedDate><_x0039_70841e1-1ccb-4d27-8baf-c5add2b21d31 type="System.String"></_x0039_70841e1-1ccb-4d27-8baf-c5add2b21d31><_x0038_2e9067b-eb80-41b2-8749-6731cae0ed55 type="System.String"></_x0038_2e9067b-eb80-41b2-8749-6731cae0ed55><IncidentHours type="System.String">14</IncidentHours><IncidentMinutes type="System.String">29</IncidentMinutes><ReportedHours type="System.String">14</ReportedHours><ReportedMinutes type="System.String">29</ReportedMinutes><InvestigationTeamLeadLastName type="System.String"></InvestigationTeamLeadLastName><_x0036_cc0fab4-d4d5-4c2d-864f-30a56929690f type="System.String"></_x0036_cc0fab4-d4d5-4c2d-864f-30a56929690f><e15c2131-7632-4a87-a0b1-599ef3e0dc60 type="System.String"></e15c2131-7632-4a87-a0b1-599ef3e0dc60><e6ee3f8d-8d20-4546-84ae-91365d05dbc6 type="System.String"></e6ee3f8d-8d20-4546-84ae-91365d05dbc6><_x0035_98ea785-f97b-4bb9-8700-94af8023aedc type="System.String"></_x0035_98ea785-f97b-4bb9-8700-94af8023aedc><d8f58c2c-571b-4ca1-95ec-5636cf36eab4 type="System.String"></d8f58c2c-571b-4ca1-95ec-5636cf36eab4><_x0031_80817f4-d4f9-4e80-aa18-d45fe5fddfb2 type="System.String"></_x0031_80817f4-d4f9-4e80-aa18-d45fe5fddfb2><_x0031_e0e5af5-6756-47f5-86e4-6c210b4473cf type="System.String"></_x0031_e0e5af5-6756-47f5-86e4-6c210b4473cf><_x0037_ca54afc-1b81-4726-8f9a-39d4fffce5ea type="System.String"></_x0037_ca54afc-1b81-4726-8f9a-39d4fffce5ea><_x0035_b811c67-68b7-4ebc-99b6-7405e82ca62c type="System.String"></_x0035_b811c67-68b7-4ebc-99b6-7405e82ca62c><f6073a85-5c84-4b9c-912d-4689c5d39326 type="System.String"></f6073a85-5c84-4b9c-912d-4689c5d39326><ddbc6c72-9751-4ec3-b6e6-d0f1743a5424 type="System.String"></ddbc6c72-9751-4ec3-b6e6-d0f1743a5424><_x0039_d88cc01-ddb5-41a9-bef8-f1c4cdb8f36f type="System.String"></_x0039_d88cc01-ddb5-41a9-bef8-f1c4cdb8f36f><_x0034_4c525dc-a5b7-4ae2-a182-00fcde301f81 type="System.String"></_x0034_4c525dc-a5b7-4ae2-a182-00fcde301f81><_x0032_29cc80e-6d8b-4a70-a1db-9a6698c00e31 type="System.String"></_x0032_29cc80e-6d8b-4a70-a1db-9a6698c00e31><bbfc2841-35bc-4db2-b065-5214a9b54233 type="System.String"></bbfc2841-35bc-4db2-b065-5214a9b54233><_x0038_67a5f32-8eab-4a4a-a8af-6a911df3cf23 type="System.String"></_x0038_67a5f32-8eab-4a4a-a8af-6a911df3cf23><IncidentDate type="System.DateTime">04/18/2018 00:00:00</IncidentDate><InvestigationTeamLeadFirstName type="System.String"></InvestigationTeamLeadFirstName><_x0034_18b44a6-533e-454d-b7c5-2074b19d2fc7 type="System.String">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;RepeaterData&gt;&lt;Version /&gt;&lt;Items&gt;&lt;Item&gt;&lt;InvestigationTeamMemberLastName type=&quot;System.String&quot;&gt;&lt;/InvestigationTeamMemberLastName&gt;&lt;InvestigationTeamMemberLastName type=&quot;System.String&quot;&gt;&lt;/InvestigationTeamMemberLastName&gt;&lt;InvestigativeTeamMembersPosition type=&quot;System.String&quot;&gt;&lt;/InvestigativeTeamMembersPosition&gt;&lt;InvestigativeTeamMembersCompany type=&quot;System.String&quot;&gt;&lt;/InvestigativeTeamMembersCompany&gt;&lt;InvestigativeTeamMembersWPCMember type=&quot;System.Boolean&quot;&gt;False&lt;/InvestigativeTeamMembersWPCMember&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RepeaterData&gt;</_x0034_18b44a6-533e-454d-b7c5-2074b19d2fc7><_x0036_9cb4868-0ffe-4beb-9e13-e579f28579a4 type="System.String">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;RepeaterData&gt;&lt;Version /&gt;&lt;Items&gt;&lt;Item&gt;&lt;OtherSignificantContributingCasualFactor type=&quot;System.String&quot;&gt;&lt;/OtherSignificantContributingCasualFactor&gt;&lt;OtherSignificantContributingCasualFactorExplanation type=&quot;System.String&quot;&gt;&lt;/OtherSignificantContributingCasualFactorExplanation&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RepeaterData&gt;</_x0036_9cb4868-0ffe-4beb-9e13-e579f28579a4><e98fe627-52b7-4730-9882-c41e08677c7b type="System.String">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;RepeaterData&gt;&lt;Version /&gt;&lt;Items&gt;&lt;Item&gt;&lt;d26cd9ee-212f-491d-9d13-a1c810fcfa4e type=&quot;System.String&quot;&gt;&lt;/d26cd9ee-212f-491d-9d13-a1c810fcfa4e&gt;&lt;_x0032_94476fd-4b00-46cf-9269-30d56b991daf type=&quot;System.String&quot;&gt;&lt;/_x0032_94476fd-4b00-46cf-9269-30d56b991daf&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RepeaterData&gt;</e98fe627-52b7-4730-9882-c41e08677c7b><RepSec_CorrectiveActions type="System.String"><?xml version="1.0" encoding="utf-8"?><RepeaterData><Version /><Items><Item><Rep_CorrectiveAction type="System.String">CA 1</Rep_CorrectiveAction><Rep_ResponsiblePerson type="System.String">i:0#.w|abckp</Rep_ResponsiblePerson><Rep_DueDate type="System.DateTime">05/03/2018 00:00:00</Rep_DueDate><Rep_HCAI_IDNo type="System.String">91</Rep_HCAI_IDNo></Item><Item><Rep_CorrectiveAction type="System.String">CA 2</Rep_CorrectiveAction><Rep_ResponsiblePerson type="System.String">i:0#.w|abc j</Rep_ResponsiblePerson><Rep_DueDate type="System.DateTime">04/21/2018 00:00:00</Rep_DueDate><Rep_HCAI_IDNo type="System.String">92</Rep_HCAI_IDNo></Item></Items></RepeaterData></RepSec_CorrectiveActions><Attachments_x0020_1 type="System.String"></Attachments_x0020_1></FormVariables>
how did you encode it?
there still seems ampersands and quotations marks not to be encoded
+12
After finishing the loop, when I got the final modified XML, I used build string and used xml encode function and then used that xml to insert in form data using update xml action.
try to xml encode value to update with directly within XML update action.
+12
But I'm confused, what difference it's going to make !!!
it rules out any possible places/actions that could convert already XML encoded characters back to their ASCII interpretation.
+12
I tried to encode xml in update xml and still getting correlation error.
have you checked what exactly has been written to FormData field?
I would once again suggested to work with dedicated plaintext list field for repeating section. it will be much easier then working with FormData field.
if you insist on FormData field then I would suggest to make a proof of concept project with very simple form, with only repeating section and no other fields so that FormData content is very simple and clear and you could immediatelly see what exactly is going on in there.
+12
I've tried to create a separate list with just repeating section and still having the same issue.
Below are my XML code from that list:
- Original Form Data:
<?xml version="1.0" encoding="utf-8"?><FormVariables><Version /><RepSecCorrectiveActions type="System.String">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;RepeaterData&gt;&lt;Version /&gt;&lt;Items&gt;&lt;Item&gt;&lt;RepSec_CA type=&quot;System.String&quot;&gt;CA 1.3&lt;/RepSec_CA&gt;&lt;RepSec_DueDate type=&quot;System.DateTime&quot;&gt;05/26/2018 00:00:00&lt;/RepSec_DueDate&gt;&lt;RepSec_RespPerson type=&quot;System.String&quot;&gt;i:0#.w|domainuser1&lt;/RepSec_RespPerson&gt;&lt;RepSec_HCAIID type=&quot;System.String&quot;&gt;&lt;/RepSec_HCAIID&gt;&lt;/Item&gt;&lt;Item&gt;&lt;RepSec_CA type=&quot;System.String&quot;&gt;CA 2.3&lt;/RepSec_CA&gt;&lt;RepSec_DueDate type=&quot;System.DateTime&quot;&gt;05/16/2018 00:00:00&lt;/RepSec_DueDate&gt;&lt;RepSec_RespPerson type=&quot;System.String&quot;&gt;i:0#.w|domainuser2&lt;/RepSec_RespPerson&gt;&lt;RepSec_HCAIID type=&quot;System.String&quot;&gt;&lt;/RepSec_HCAIID&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RepeaterData&gt;</RepSecCorrectiveActions></FormVariables>
- Repeating Section XML from UDA (before loop starts):
<?xml version="1.0" encoding="utf-8"?><RepeaterData><Version /><Items><Item><RepSec_CA type="System.String">CA 1.3</RepSec_CA><RepSec_DueDate type="System.DateTime">05/26/2018 00:00:00</RepSec_DueDate><RepSec_RespPerson type="System.String">i:0#.w|domainuser1</RepSec_RespPerson><RepSec_HCAIID type="System.String"></RepSec_HCAIID></Item><Item><RepSec_CA type="System.String">CA 2.3</RepSec_CA><RepSec_DueDate type="System.DateTime">05/16/2018 00:00:00</RepSec_DueDate><RepSec_RespPerson type="System.String">i:0#.w|domainuser2</RepSec_RespPerson><RepSec_HCAIID type="System.String"></RepSec_HCAIID></Item></Items></RepeaterData>
- Repeating Section XML After Loop Ends:
<?xml version="1.0" encoding="utf-8"?><RepeaterData><Version /><Items><Item><RepSec_CA type="System.String">CA 1.3</RepSec_CA><RepSec_DueDate type="System.DateTime">05/26/2018 00:00:00</RepSec_DueDate><RepSec_RespPerson type="System.String">i:0#.w|domainuser1</RepSec_RespPerson><RepSec_HCAIID type="System.String">4</RepSec_HCAIID></Item><Item><RepSec_CA type="System.String">CA 2.3</RepSec_CA><RepSec_DueDate type="System.DateTime">05/16/2018 00:00:00</RepSec_DueDate><RepSec_RespPerson type="System.String">i:0#.w|domainuser2</RepSec_RespPerson><RepSec_HCAIID type="System.String">5</RepSec_HCAIID></Item></Items></RepeaterData>
- Modified Form Data From Update XML With Encode Function:
<?xml version="1.0" encoding="utf-8"?><FormVariables><Version /><RepSecCorrectiveActions type="System.String"><?xml version="1.0" encoding="utf-8"?><RepeaterData><Version /><Items><Item><RepSec_CA type="System.String">CA 1.3</RepSec_CA><RepSec_DueDate type="System.DateTime">05/26/2018 00:00:00</RepSec_DueDate><RepSec_RespPerson type="System.String">i:0#.w|domainuser1</RepSec_RespPerson><RepSec_HCAIID type="System.String">4</RepSec_HCAIID></Item><Item><RepSec_CA type="System.String">CA 2.3</RepSec_CA><RepSec_DueDate type="System.DateTime">05/16/2018 00:00:00</RepSec_DueDate><RepSec_RespPerson type="System.String">i:0#.w|domainuser2</RepSec_RespPerson><RepSec_HCAIID type="System.String">5</RepSec_HCAIID></Item></Items></RepeaterData></RepSecCorrectiveActions></FormVariables>
********************************
After doing all these, still getting an error message.
Thanks
you still seem not to have correctly encoded some characters
if I take your "Repeating Section XML After Loop Ends" XML and encode it I do get correctly encoded output (just like your source XML)
can you test following scenario with above mentioned XML what output do you get ?
Reply
View our Community Site Map
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.