cancel
Showing results for 
Search instead for 
Did you mean: 
Automation Master
Automation Master

Update Form Data Using Update Query XML

Jump to solution

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.

Labels: (2)
0 Kudos
Reply
18 Replies
Automation Master
Automation Master

Re: Update Form Data Using Update Query XML

Jump to solution

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

0 Kudos
Reply
Automation Master
Automation Master

Re: Update Form Data Using Update Query XML

Jump to solution

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.

0 Kudos
Reply
Automation Master
Automation Master

Re: Update Form Data Using Update Query XML

Jump to solution

‌, thanks for your response.

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

0 Kudos
Reply
Automation Master
Automation Master

Re: Update Form Data Using Update Query XML

Jump to solution

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)

0 Kudos
Reply
Automation Master
Automation Master

Re: Update Form Data Using Update Query XML

Jump to solution

Marian Hatala‌,

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:

  1. Get Form data from current item
  2. Store that in a variable
  3. 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).
  4. Set Index as 1
  5. Run loop if index is less than or equal to # of rows
    1. Query XML - Source is Repeating Section's XML and getting all 4 fields' value
    2. Create Item in another list (storing ID of list item which got created in a variable)
    3. Converting above ID to string since in repeating section it's string value
    4. Update my Repeating Section XML with this ID using Update XML action
    5. Increase index by 1
  6. After the loop is over, I'm updating my form data XML using step 5(d) data (I'm selecting replace node contents)
  7. Now using updated form data xml, I'm updating the current item
  8. 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.

0 Kudos
Reply
Automation Master
Automation Master

Re: Update Form Data Using Update Query XML

Jump to solution

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

0 Kudos
Reply
Automation Master
Automation Master

Re: Update Form Data Using Update Query XML

Jump to solution

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 abc\kp and abc\rj.

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">&amp;lt;?xml version=&amp;quot;1.0&amp;quot; encoding=&amp;quot;utf-8&amp;quot;?&amp;gt;&amp;lt;RepeaterData&amp;gt;&amp;lt;Version /&amp;gt;&amp;lt;Items&amp;gt;&amp;lt;Item&amp;gt;&amp;lt;InvestigationTeamMemberLastName type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/InvestigationTeamMemberLastName&amp;gt;&amp;lt;InvestigationTeamMemberLastName type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/InvestigationTeamMemberLastName&amp;gt;&amp;lt;InvestigativeTeamMembersPosition type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/InvestigativeTeamMembersPosition&amp;gt;&amp;lt;InvestigativeTeamMembersCompany type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/InvestigativeTeamMembersCompany&amp;gt;&amp;lt;InvestigativeTeamMembersWPCMember type=&amp;quot;System.Boolean&amp;quot;&amp;gt;False&amp;lt;/InvestigativeTeamMembersWPCMember&amp;gt;&amp;lt;/Item&amp;gt;&amp;lt;/Items&amp;gt;&amp;lt;/RepeaterData&amp;gt;</_x0034_18b44a6-533e-454d-b7c5-2074b19d2fc7><_x0036_9cb4868-0ffe-4beb-9e13-e579f28579a4 type="System.String">&amp;lt;?xml version=&amp;quot;1.0&amp;quot; encoding=&amp;quot;utf-8&amp;quot;?&amp;gt;&amp;lt;RepeaterData&amp;gt;&amp;lt;Version /&amp;gt;&amp;lt;Items&amp;gt;&amp;lt;Item&amp;gt;&amp;lt;OtherSignificantContributingCasualFactor type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/OtherSignificantContributingCasualFactor&amp;gt;&amp;lt;OtherSignificantContributingCasualFactorExplanation type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/OtherSignificantContributingCasualFactorExplanation&amp;gt;&amp;lt;/Item&amp;gt;&amp;lt;/Items&amp;gt;&amp;lt;/RepeaterData&amp;gt;</_x0036_9cb4868-0ffe-4beb-9e13-e579f28579a4><e98fe627-52b7-4730-9882-c41e08677c7b type="System.String">&amp;lt;?xml version=&amp;quot;1.0&amp;quot; encoding=&amp;quot;utf-8&amp;quot;?&amp;gt;&amp;lt;RepeaterData&amp;gt;&amp;lt;Version /&amp;gt;&amp;lt;Items&amp;gt;&amp;lt;Item&amp;gt;&amp;lt;d26cd9ee-212f-491d-9d13-a1c810fcfa4e type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/d26cd9ee-212f-491d-9d13-a1c810fcfa4e&amp;gt;&amp;lt;_x0032_94476fd-4b00-46cf-9269-30d56b991daf type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/_x0032_94476fd-4b00-46cf-9269-30d56b991daf&amp;gt;&amp;lt;/Item&amp;gt;&amp;lt;/Items&amp;gt;&amp;lt;/RepeaterData&amp;gt;</e98fe627-52b7-4730-9882-c41e08677c7b><RepSec_CorrectiveActions type="System.String">&amp;lt;?xml version=&amp;quot;1.0&amp;quot; encoding=&amp;quot;utf-8&amp;quot;?&amp;gt;&amp;lt;RepeaterData&amp;gt;&amp;lt;Version /&amp;gt;&amp;lt;Items&amp;gt;&amp;lt;Item&amp;gt;&amp;lt;Rep_CorrectiveAction type=&amp;quot;System.String&amp;quot;&amp;gt;Test CA 01&amp;lt;/Rep_CorrectiveAction&amp;gt;&amp;lt;Rep_ResponsiblePerson type=&amp;quot;System.String&amp;quot;&amp;gt;i:0#.w|abc\kp&amp;lt;/Rep_ResponsiblePerson&amp;gt;&amp;lt;Rep_DueDate type=&amp;quot;System.DateTime&amp;quot;&amp;gt;05/04/2018 00:00:00&amp;lt;/Rep_DueDate&amp;gt;&amp;lt;Rep_HCAI_IDNo type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/Rep_HCAI_IDNo&amp;gt;&amp;lt;/Item&amp;gt;&amp;lt;Item&amp;gt;&amp;lt;Rep_CorrectiveAction type=&amp;quot;System.String&amp;quot;&amp;gt;Test CA 02&amp;lt;/Rep_CorrectiveAction&amp;gt;&amp;lt;Rep_ResponsiblePerson type=&amp;quot;System.String&amp;quot;&amp;gt;i:0#.w|abc\rj&amp;lt;/Rep_ResponsiblePerson&amp;gt;&amp;lt;Rep_DueDate type=&amp;quot;System.DateTime&amp;quot;&amp;gt;05/05/2018 00:00:00&amp;lt;/Rep_DueDate&amp;gt;&amp;lt;Rep_HCAI_IDNo type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/Rep_HCAI_IDNo&amp;gt;&amp;lt;/Item&amp;gt;&amp;lt;/Items&amp;gt;&amp;lt;/RepeaterData&amp;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|abc\kp</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\rj</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|abc\kp</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\rj</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">&amp;lt;?xml version=&amp;quot;1.0&amp;quot; encoding=&amp;quot;utf-8&amp;quot;?&amp;gt;&amp;lt;RepeaterData&amp;gt;&amp;lt;Version /&amp;gt;&amp;lt;Items&amp;gt;&amp;lt;Item&amp;gt;&amp;lt;InvestigationTeamMemberLastName type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/InvestigationTeamMemberLastName&amp;gt;&amp;lt;InvestigationTeamMemberLastName type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/InvestigationTeamMemberLastName&amp;gt;&amp;lt;InvestigativeTeamMembersPosition type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/InvestigativeTeamMembersPosition&amp;gt;&amp;lt;InvestigativeTeamMembersCompany type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/InvestigativeTeamMembersCompany&amp;gt;&amp;lt;InvestigativeTeamMembersWPCMember type=&amp;quot;System.Boolean&amp;quot;&amp;gt;False&amp;lt;/InvestigativeTeamMembersWPCMember&amp;gt;&amp;lt;/Item&amp;gt;&amp;lt;/Items&amp;gt;&amp;lt;/RepeaterData&amp;gt;</_x0034_18b44a6-533e-454d-b7c5-2074b19d2fc7><_x0036_9cb4868-0ffe-4beb-9e13-e579f28579a4 type="System.String">&amp;lt;?xml version=&amp;quot;1.0&amp;quot; encoding=&amp;quot;utf-8&amp;quot;?&amp;gt;&amp;lt;RepeaterData&amp;gt;&amp;lt;Version /&amp;gt;&amp;lt;Items&amp;gt;&amp;lt;Item&amp;gt;&amp;lt;OtherSignificantContributingCasualFactor type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/OtherSignificantContributingCasualFactor&amp;gt;&amp;lt;OtherSignificantContributingCasualFactorExplanation type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/OtherSignificantContributingCasualFactorExplanation&amp;gt;&amp;lt;/Item&amp;gt;&amp;lt;/Items&amp;gt;&amp;lt;/RepeaterData&amp;gt;</_x0036_9cb4868-0ffe-4beb-9e13-e579f28579a4><e98fe627-52b7-4730-9882-c41e08677c7b type="System.String">&amp;lt;?xml version=&amp;quot;1.0&amp;quot; encoding=&amp;quot;utf-8&amp;quot;?&amp;gt;&amp;lt;RepeaterData&amp;gt;&amp;lt;Version /&amp;gt;&amp;lt;Items&amp;gt;&amp;lt;Item&amp;gt;&amp;lt;d26cd9ee-212f-491d-9d13-a1c810fcfa4e type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/d26cd9ee-212f-491d-9d13-a1c810fcfa4e&amp;gt;&amp;lt;_x0032_94476fd-4b00-46cf-9269-30d56b991daf type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/_x0032_94476fd-4b00-46cf-9269-30d56b991daf&amp;gt;&amp;lt;/Item&amp;gt;&amp;lt;/Items&amp;gt;&amp;lt;/RepeaterData&amp;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|abc\kp</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\rj</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>

***************************************************************************************************

0 Kudos
Reply
Automation Master
Automation Master

Re: Update Form Data Using Update Query XML

Jump to solution

have you compared the two XMLs?

if you have, you would immediately spot the difference - you have to XMLEncode() repeater XML snippet

0 Kudos
Reply
Automation Master
Automation Master

Re: Update Form Data Using Update Query XML

Jump to solution

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">&amp;lt;?xml version=&amp;quot;1.0&amp;quot; encoding=&amp;quot;utf-8&amp;quot;?&amp;gt;&amp;lt;RepeaterData&amp;gt;&amp;lt;Version /&amp;gt;&amp;lt;Items&amp;gt;&amp;lt;Item&amp;gt;&amp;lt;InvestigationTeamMemberLastName type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/InvestigationTeamMemberLastName&amp;gt;&amp;lt;InvestigationTeamMemberLastName type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/InvestigationTeamMemberLastName&amp;gt;&amp;lt;InvestigativeTeamMembersPosition type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/InvestigativeTeamMembersPosition&amp;gt;&amp;lt;InvestigativeTeamMembersCompany type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/InvestigativeTeamMembersCompany&amp;gt;&amp;lt;InvestigativeTeamMembersWPCMember type=&amp;quot;System.Boolean&amp;quot;&amp;gt;False&amp;lt;/InvestigativeTeamMembersWPCMember&amp;gt;&amp;lt;/Item&amp;gt;&amp;lt;/Items&amp;gt;&amp;lt;/RepeaterData&amp;gt;</_x0034_18b44a6-533e-454d-b7c5-2074b19d2fc7><_x0036_9cb4868-0ffe-4beb-9e13-e579f28579a4 type="System.String">&amp;lt;?xml version=&amp;quot;1.0&amp;quot; encoding=&amp;quot;utf-8&amp;quot;?&amp;gt;&amp;lt;RepeaterData&amp;gt;&amp;lt;Version /&amp;gt;&amp;lt;Items&amp;gt;&amp;lt;Item&amp;gt;&amp;lt;OtherSignificantContributingCasualFactor type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/OtherSignificantContributingCasualFactor&amp;gt;&amp;lt;OtherSignificantContributingCasualFactorExplanation type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/OtherSignificantContributingCasualFactorExplanation&amp;gt;&amp;lt;/Item&amp;gt;&amp;lt;/Items&amp;gt;&amp;lt;/RepeaterData&amp;gt;</_x0036_9cb4868-0ffe-4beb-9e13-e579f28579a4><e98fe627-52b7-4730-9882-c41e08677c7b type="System.String">&amp;lt;?xml version=&amp;quot;1.0&amp;quot; encoding=&amp;quot;utf-8&amp;quot;?&amp;gt;&amp;lt;RepeaterData&amp;gt;&amp;lt;Version /&amp;gt;&amp;lt;Items&amp;gt;&amp;lt;Item&amp;gt;&amp;lt;d26cd9ee-212f-491d-9d13-a1c810fcfa4e type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/d26cd9ee-212f-491d-9d13-a1c810fcfa4e&amp;gt;&amp;lt;_x0032_94476fd-4b00-46cf-9269-30d56b991daf type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/_x0032_94476fd-4b00-46cf-9269-30d56b991daf&amp;gt;&amp;lt;/Item&amp;gt;&amp;lt;/Items&amp;gt;&amp;lt;/RepeaterData&amp;gt;</e98fe627-52b7-4730-9882-c41e08677c7b><RepSec_CorrectiveActions type="System.String">&amp;lt;?xml version=&amp;quot;1.0&amp;quot; encoding=&amp;quot;utf-8&amp;quot;?&amp;gt;&amp;lt;RepeaterData&amp;gt;&amp;lt;Version /&amp;gt;&amp;lt;Items&amp;gt;&amp;lt;Item&amp;gt;&amp;lt;Rep_CorrectiveAction type=&amp;quot;System.String&amp;quot;&amp;gt;CA 1&amp;lt;/Rep_CorrectiveAction&amp;gt;&amp;lt;Rep_ResponsiblePerson type=&amp;quot;System.String&amp;quot;&amp;gt;i:0#.w|abc\kp&amp;lt;/Rep_ResponsiblePerson&amp;gt;&amp;lt;Rep_DueDate type=&amp;quot;System.DateTime&amp;quot;&amp;gt;05/03/2018 00:00:00&amp;lt;/Rep_DueDate&amp;gt;&amp;lt;Rep_HCAI_IDNo type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/Rep_HCAI_IDNo&amp;gt;&amp;lt;/Item&amp;gt;&amp;lt;Item&amp;gt;&amp;lt;Rep_CorrectiveAction type=&amp;quot;System.String&amp;quot;&amp;gt;CA 2&amp;lt;/Rep_CorrectiveAction&amp;gt;&amp;lt;Rep_ResponsiblePerson type=&amp;quot;System.String&amp;quot;&amp;gt;i:0#.w|abc\rj&amp;lt;/Rep_ResponsiblePerson&amp;gt;&amp;lt;Rep_DueDate type=&amp;quot;System.DateTime&amp;quot;&amp;gt;04/21/2018 00:00:00&amp;lt;/Rep_DueDate&amp;gt;&amp;lt;Rep_HCAI_IDNo type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/Rep_HCAI_IDNo&amp;gt;&amp;lt;/Item&amp;gt;&amp;lt;/Items&amp;gt;&amp;lt;/RepeaterData&amp;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">&amp;lt;?xml version=&amp;quot;1.0&amp;quot; encoding=&amp;quot;utf-8&amp;quot;?&amp;gt;&amp;lt;RepeaterData&amp;gt;&amp;lt;Version /&amp;gt;&amp;lt;Items&amp;gt;&amp;lt;Item&amp;gt;&amp;lt;InvestigationTeamMemberLastName type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/InvestigationTeamMemberLastName&amp;gt;&amp;lt;InvestigationTeamMemberLastName type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/InvestigationTeamMemberLastName&amp;gt;&amp;lt;InvestigativeTeamMembersPosition type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/InvestigativeTeamMembersPosition&amp;gt;&amp;lt;InvestigativeTeamMembersCompany type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/InvestigativeTeamMembersCompany&amp;gt;&amp;lt;InvestigativeTeamMembersWPCMember type=&amp;quot;System.Boolean&amp;quot;&amp;gt;False&amp;lt;/InvestigativeTeamMembersWPCMember&amp;gt;&amp;lt;/Item&amp;gt;&amp;lt;/Items&amp;gt;&amp;lt;/RepeaterData&amp;gt;</_x0034_18b44a6-533e-454d-b7c5-2074b19d2fc7><_x0036_9cb4868-0ffe-4beb-9e13-e579f28579a4 type="System.String">&amp;lt;?xml version=&amp;quot;1.0&amp;quot; encoding=&amp;quot;utf-8&amp;quot;?&amp;gt;&amp;lt;RepeaterData&amp;gt;&amp;lt;Version /&amp;gt;&amp;lt;Items&amp;gt;&amp;lt;Item&amp;gt;&amp;lt;OtherSignificantContributingCasualFactor type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/OtherSignificantContributingCasualFactor&amp;gt;&amp;lt;OtherSignificantContributingCasualFactorExplanation type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/OtherSignificantContributingCasualFactorExplanation&amp;gt;&amp;lt;/Item&amp;gt;&amp;lt;/Items&amp;gt;&amp;lt;/RepeaterData&amp;gt;</_x0036_9cb4868-0ffe-4beb-9e13-e579f28579a4><e98fe627-52b7-4730-9882-c41e08677c7b type="System.String">&amp;lt;?xml version=&amp;quot;1.0&amp;quot; encoding=&amp;quot;utf-8&amp;quot;?&amp;gt;&amp;lt;RepeaterData&amp;gt;&amp;lt;Version /&amp;gt;&amp;lt;Items&amp;gt;&amp;lt;Item&amp;gt;&amp;lt;d26cd9ee-212f-491d-9d13-a1c810fcfa4e type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/d26cd9ee-212f-491d-9d13-a1c810fcfa4e&amp;gt;&amp;lt;_x0032_94476fd-4b00-46cf-9269-30d56b991daf type=&amp;quot;System.String&amp;quot;&amp;gt;&amp;lt;/_x0032_94476fd-4b00-46cf-9269-30d56b991daf&amp;gt;&amp;lt;/Item&amp;gt;&amp;lt;/Items&amp;gt;&amp;lt;/RepeaterData&amp;gt;</e98fe627-52b7-4730-9882-c41e08677c7b><RepSec_CorrectiveActions type="System.String">&lt;?xml version="1.0" encoding="utf-8"?&gt;&lt;RepeaterData&gt;&lt;Version /&gt;&lt;Items&gt;&lt;Item&gt;&lt;Rep_CorrectiveAction type="System.String"&gt;CA 1&lt;/Rep_CorrectiveAction&gt;&lt;Rep_ResponsiblePerson type="System.String"&gt;i:0#.w|abc\kp&lt;/Rep_ResponsiblePerson&gt;&lt;Rep_DueDate type="System.DateTime"&gt;05/03/2018 00:00:00&lt;/Rep_DueDate&gt;&lt;Rep_HCAI_IDNo type="System.String"&gt;91&lt;/Rep_HCAI_IDNo&gt;&lt;/Item&gt;&lt;Item&gt;&lt;Rep_CorrectiveAction type="System.String"&gt;CA 2&lt;/Rep_CorrectiveAction&gt;&lt;Rep_ResponsiblePerson type="System.String"&gt;i:0#.w|abc\rj&lt;/Rep_ResponsiblePerson&gt;&lt;Rep_DueDate type="System.DateTime"&gt;04/21/2018 00:00:00&lt;/Rep_DueDate&gt;&lt;Rep_HCAI_IDNo type="System.String"&gt;92&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>

0 Kudos
Reply