cancel
Showing results for 
Search instead for 
Did you mean: 
muldeer
Nintex Newbie

Populate existing SP column

Jump to solution

I have a nintex form (on premisses) attached to a SP list. (SP 2013)

I have created an extra SP column that should display information from one off the form fields, this is an existing field.

How can i populatie this SP column with the field value which is on the form for existing form entries.

for new forms thats not a problem as the field is connected to the SP column.

Labels: (2)
0 Kudos
Reply
16 Replies
emha
Nintex Newbie

Re: Populate existing SP column

Jump to solution

I believe this is what you need  

Reply
muldeer
Nintex Newbie

Re: Populate existing SP column

Jump to solution

Thanks this is what i mean.

I understand the solution in general but building it is something harder.

I have tried some creating a workflow with the folowing steps.

- query the list outputting the listid to a workflow variable SP-listid (type collection)

- then a for each control with a "target collection" the SP-listid and "store result in" a workflow variable WF-listid (Type: listitemID)

-then a query XMl with source XML: {ItemProperty:FormData} and output Xpath with /FormVariables/<var name> and store result in a workflow variable 'WF-cause' (type: single line of text)

- then i have a Log in History list and i am outputting the WF-LIst id an the WF-cause variables. I can see the WF-listid displaying al id nummers but the WF-cause variable is always the same (so not displaying the actual value of the form) but repeating the fist entry. So it's not itterating throug the forms...

So i am doing something wrong. Can somebody put me in the good direction (or even better have an example)

Reply
emha
Nintex Newbie

Re: Populate existing SP column

Jump to solution

if you 'Query XML' from item property you always read field from the item the workflow is running on, regardless of what data you get in loop.

so either:

- create a list workflow and query from item property. then you do not need to query list for all the items nor loop but rather start the workflow on every item that needs to update list field from FormData field

- or create a site workflow with the structure as you described. but along with itemID query as well FormData field to a separate collection and within the loop 'Query XML' from respective element of FormsData collection.

0 Kudos
Reply
muldeer
Nintex Newbie

Re: Populate existing SP column

Jump to solution

Marion, thanks for helping me.

I am trying the second option so i have added the formsdata as a seperate collection

But i am having trouble to find the exact XML xpath output. Wat is the easiest way to find the code for the field i want to have?

So how can i find the respective element and how does it look like?

Reply
emha
Nintex Newbie

Re: Populate existing SP column

Jump to solution

send FormData XML from one item to yourself by mail notification (plaintext) as an example.

then copy XML over into XPath builder within Query XML action. that should help you to build XPath (it's not 100% reliable but at least can give you good hint).

if you do not manage it to do it that way, post example form data XML here.

Reply
muldeer
Nintex Newbie

Re: Populate existing SP column

Jump to solution

i have send it in plain text to me by mail. i got

I need the value off the bold field: eg Business Change

<?xml version="1.0" encoding="utf-8"?><FormVariables><Version /><IssueDescription type="System.String">Regenerated pallet label is a different format to the original </IssueDescription><Database type="System.String">Live Core</Database><NumberOffUsersAffected type="System.Int32">10</NumberOffUsersAffected><IssueCause type="System.String">Business Change</IssueCause><ReportedSupplier type="System.Boolean">True</ReportedSupplier><SupplierName type="System.String">GAC</SupplierName><f5301f3c-c044-44d7-a65a-6d54835a1004 type="System.DateTime">11/01/2016 00:00:00</f5301f3c-c044-44d7-a65a-6d54835a1004><SupplierReference type="System.String"></SupplierReference><CallLog type="System.String">This is not just the label reprint needs to be pointed to a different report as the way it is setup to print labels from a production order is not the same. The format of the reprinted label needs to be changed so that it prints the label for the line selected. This will be a development and will need the change to be documented and added to the development list. This is not an issue but a developemht request.

 

Will be presented to the project board after go live HGS.

 

PN 95 &amp;amp;nbsp;has been raised on GAC site and some development has now been done.</CallLog><c6728554-1766-42eb-9e75-bdc36290b873 type="System.String">Development required - requirements to be defined</c6728554-1766-42eb-9e75-bdc36290b873><Teller type="System.Int32">1</Teller><CreationDate type="System.String">26-01-17</CreationDate><CreatedBy type="System.String">Brown, Michael</CreatedBy><Attachments type="System.String"></Attachments><e42e4f8c-e137-4aa7-b58a-bfd2990ef324 type="System.String"></e42e4f8c-e137-4aa7-b58a-bfd2990ef324></FormVariables>

Reply
emha
Nintex Newbie

Re: Populate existing SP column

Jump to solution

following XPath should work for you

/FormVariables/IssueCause

Reply
muldeer
Nintex Newbie

Re: Populate existing SP column

Jump to solution

Hi all this is very helfull so finally (sorry for my lack of knowledge) I now can iterate trought the collection and have the value from the form stored in a workflow variable.

So next step is to update every SP list item with that value.

I have tried the 'update item' component but doet doesn't work. I think its is because it is not the SPlist it iterates but the collection.

In the solution supplied i read:

- parse that XML out for respective control name/guid and its value

- update new list column with that value

So what does this mean in terms of nintex controls?

Erik

0 Kudos
Reply
emha
Nintex Newbie

Re: Populate existing SP column

Jump to solution

can you clarify which way you decided to go on? did you create list or site workflow?

can you post how does your workflow looks like and what's the configuration of update item action?

0 Kudos
Reply