Skip to main content
Nintex Community Menu Bar

The repeating section when using List Loockup to List sharepoint value

  • Jun 1, 2017 4:46 PM UTC
  • 15 replies
  • 23 views
  • Translate All

Forum|alt.badge.img+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

Forum|alt.badge.img+7
  • Nintex Partner
  • Jun 1, 2017 5:49 PM UTC

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.

Translate

Forum|alt.badge.img+14
  • Scholar
  • Jun 1, 2017 11:16 PM UTC

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

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

Translate

Forum|alt.badge.img+7
  • Author
  • Rookie
  • Jun 4, 2017 4:40 PM UTC
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?
Translate

Forum|alt.badge.img+14
  • Scholar
  • Jun 6, 2017 7:27 AM UTC

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?

Translate

Forum|alt.badge.img+7
  • Nintex Partner
  • Jun 6, 2017 9:25 AM UTC

Pass me the XML please

Translate

Forum|alt.badge.img+7
  • Author
  • Rookie
  • Jun 6, 2017 9:19 PM UTC
<?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>
Translate

Forum|alt.badge.img+7
  • Nintex Partner
  • Jun 7, 2017 10:48 AM UTC


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

Check it and get back to me.

Translate

Forum|alt.badge.img+7
  • Author
  • Rookie
  • Jun 7, 2017 11:14 AM UTC

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

example:

Translate

Forum|alt.badge.img+7
  • Author
  • Rookie
  • Jun 7, 2017 11:43 AM UTC

Only return the first line

Translate

Forum|alt.badge.img+14
  • Scholar
  • Jun 7, 2017 11:59 AM UTC

but is text or collection variable?

can you post its config?

Translate

Forum|alt.badge.img+7
  • Author
  • Rookie
  • Jun 7, 2017 1:54 PM UTC

Is a multiple line of text

Translate

Forum|alt.badge.img+7
  • Author
  • Rookie
  • Jun 7, 2017 2:02 PM UTC

Nothing,

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

Translate

Forum|alt.badge.img+14
  • Scholar
  • Jun 7, 2017 2:28 PM UTC

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.

Translate

Forum|alt.badge.img+14
  • Scholar
  • Jun 7, 2017 3:11 PM UTC

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

Translate

Forum|alt.badge.img+7
  • Author
  • Rookie
  • Jun 10, 2017 12:42 PM UTC

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:

Translate