Update an item if it exists, create it if it does not exist?

  • 2 February 2016
  • 4 replies
  • 3 views

Badge +8

I am brand new to Nintex.

What I am trying to do is import some data into a Sharepoint list using a Nintex workflow.    I would like to be able to lookup the item based off of a key.   If the item exists then I want to update it.  If it does not exist then I want to create it. 

I can see how to update and item, I can see how to add an item,  I can see how to query a list of items based off of a key.  

I have not worked out the details but I think I might need to do the following:

I thought I would process my input collection a value.  Look each key up in my target list.   If I get results returned, update the item.    No results then add the item.   Hopefully there is an easier way to do this?    If so how?


4 replies

Userlevel 6
Badge +16

It's right the way you thought it

Badge +9

Hi Bruce,

This Create item in another siteould help

Regards,

Christophe

Badge +11

That is the way I would've done it.

Userlevel 6
Badge +12

I agree on your approach, but what is the expected frequency of this WF? Will there always be an update or new? What about items that are not new or updated; are they still assessed?

I ask because it may be worth doing your process once and then develop and implement something that focuses your results to those that require action.

Reply