stempb
Apprentice

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

Jump to solution

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?

Reply
4 Replies
fhunth
Scout

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

Jump to solution

It's right the way you thought it

Reply
christopheraucq
Apprentice

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

Jump to solution

Hi Bruce,

This Create item in another siteould help

Regards,

Christophe

Reply
burkslm
Apprentice

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

Jump to solution

That is the way I would've done it.

0 Kudos
Reply
jesse_mchargue
Nintex Workflow Cloud Expert
Nintex Workflow Cloud Expert

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

Jump to solution

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.

0 Kudos
Reply