Complete List depending on filters with Information from List on parent site

  • 6 March 2020
  • 1 reply
  • 1 view
D
Badge +1

Hi all!

I have problem with autmotaically putting Info in a list.

 

On the Parent Site I have a List as my "Database" with the columns "Role" - "Resp. DE" - "Resp. CR" -...

Under this parent site, there can be multiple project sites that all have a list with the same Column "Role". All elements in this coloumn are identical with the List on the parent site. But: there is only one coloumn "Resp."

The coloumn "Resp." now has to be filled with information from the parent site list depending on the users input. If the choice is for example "DE", i want the workflow to copy all values from "Resp.DE" into that coloumn int the line with the same "Role" as in the parent site. 

 

The Problem really is to get the Info from parent site as i can not select a list from the parent site in the "update multiple items" action...

 

Maybe the picture attached can explain in a very simple way what i am trying to achieve...

 

Any ideas?

 

 

 

1 reply

Michel
Badge +7
Hi,

I think this process can be accomplished when using the Query List-action in Nintex Workflow. Before updating the list on the current site, the values of the parent site must be collected. Using the Query List-action can do that for you. You do have to use a CAML query, but the following URL can point you in the right direction.

https://sharepoint.protiviti.com/blog/Lists/Posts/Post.aspx?ID=89

After collecting all the necessary information, a For Each with a Create Item (or maybe the Update multiple items) can then be executed to create the multiple items in the list.

Let me know if this helps!

Kind regards,
Michel

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings