jose_fidalgo
Workflow Hero

The repeating section when using List Loockup to List sharepoint value

Jump to solution

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?

0 Kudos
Reply
15 Replies
pwarrak
Nintex Newbie

Re: The repeating section when using List Loockup save a number

Jump to solution

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.

0 Kudos
Reply
emha
Automation Master
Automation Master

Re: The repeating section when using List Loockup save a number

Jump to solution

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

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

Reply
jose_fidalgo
Workflow Hero

Re: The repeating section when using List Loockup save a number

Jump to solution
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?
0 Kudos
Reply
emha
Automation Master
Automation Master

Re: The repeating section when using List Loockup save a number

Jump to solution

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?

0 Kudos
Reply
pwarrak
Nintex Newbie

Re: The repeating section when using List Loockup save a number

Jump to solution

Pass me the XML please

0 Kudos
Reply
jose_fidalgo
Workflow Hero

Re: The repeating section when using List Loockup save a number

Jump to solution
<?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>
0 Kudos
Reply
pwarrak
Nintex Newbie

Re: The repeating section when using List Loockup save a number

Jump to solution


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

Check it and get back to me.

0 Kudos
Reply
jose_fidalgo
Workflow Hero

Re: The repeating section when using List Loockup save a number

Jump to solution

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

example:

0 Kudos
Reply
jose_fidalgo
Workflow Hero

Re: The repeating section when using List Loockup save a number

Jump to solution

Only return the first line

0 Kudos
Reply