The repeating section when using List Loockup to List sharepoint value


Badge +7

I have this repeting section with list loockup  from list of suppliers, like that

List of suppliers

Why the number appears in the XML.

So I can not convert correctly.

I already searched the forum, but I can not find a solution.

I need to pass the supplier name to the sharepoint list.

How do I solve this situation?


15 replies

Badge +7

Dear,

The number is the ID of selected item.

So if you need to pass the supplier name to the SP list:

1-Use Nintex Workflow to get this it from its List through ID.

OR

2-Add a calculated value control in the repeating section with the following formula:

parseLookup(Supplier Control Name

So you can pass the value to the list.

Userlevel 5
Badge +14

I need to pass the supplier name to the sharepoint list.

what are you going to do with suppliers Names from repeater XML?

Badge +7
I chose option 2.
I've created a calculated value control, like you said and it works fine.
I created a rule to control objects, if the view in the control is visible, if the object is in new mode or edit is not visible.
Now my problem is to put the control value in the list.
I've tried creating a workflow, but I have some issues:
1 - the "-> carecter" goes wrong, is not using uf-8 character
2- If I have more than one provider, only the first one appears in the list.
3- When I click on the view or edit mode, the vendors no longer appear even though they are created.
Can you help me?
Userlevel 5
Badge +14

can you provide some example of your repeater input (or whole XML) and what you are trying to update in list?

is 'fornecedores' variable used in query xml action a collection or some string?

Badge +7

Pass me the XML please

Badge +7
<?xml version="1.0" encoding="utf-8"?><RepeaterData><Version /><Items><Item><Exclusivo type="System.Boolean">False</Exclusivo><nomeforcalc type="System.String">AAP - ACESS&amp;#211;RIOS AUTOBARCOS, LDA -&amp;gt; 1298</nomeforcalc><nomefor type="System.String">115572</nomefor></Item><Item><Exclusivo type="System.Boolean">False</Exclusivo><nomeforcalc type="System.String">ABREU - VIAGENS -&amp;gt; 432</nomeforcalc><nomefor type="System.String">115577</nomefor></Item><Item><Exclusivo type="System.Boolean">False</Exclusivo><nomeforcalc type="System.String">ACI-AUTOMOTIVE COMPOUNDING IND.LDA -&amp;gt; 1521</nomeforcalc><nomefor type="System.String">115584</nomefor></Item></Items></RepeaterData>
Badge +7


Here the result of testing your XML,
Attached you can find the Workflow I built for testing.

Check it and get back to me.

Badge +7

The fornecedores variable is used to update field fornecedor of list, there is variable of form.

example:

Badge +7

Only return the first line

Userlevel 5
Badge +14

but is text or collection variable?

can you post its config?

Badge +7

Is a multiple line of text

Badge +7

Nothing,

I possible to used ? when i going to select field that object is not avaliable

Userlevel 5
Badge +14

that's the reason you get returned just first line (item) out of your XML!

you have to use collection variable.

then of course you can not make direct update of list item from collection variable.

you have to create for each loop over the collection, and make updates per single collection elements.

Userlevel 5
Badge +14

then you do not need to resolve lookup ID into lookup value (supplier name) in form at all.

take an ID value saved in XML and make update with inplace lookup

something like this

203849_pastedImage_1.png

Badge +7

I resolved my problem.

I have a list  that has a field supplier. This field is multitext, because it has more than one supplier.

To fill this field, I created another field, named "fornecedor" that is conected to the "Repeating Section".

The field "Fornecedor" stay with XML of the "Repeating Section".

I created the following "workflow" to fill the "Supplier" field:

Reply