Cloud Wanderer

Is it possible to create a dynamic update/create query?

I have a SharePoint List where the fields are:

Part Number

Price Level 1

Price Level 2

Price Level 3 


The user selects which Part Number and Price Level they want to update on the task form.  In the workflow, I verify whether there is already an entry in the corresponding Part Number/Price Level combination.  I can dynamically query the list based on what Price Level was selected.  Now I am trying to update the list item and the selected field only.  In SQL, I would say UPDATE [Price List] SET [Selected Price Level] = {new price} WHERE PartNumber= {Selected Part Number}.

How would I do that in Nintex Workflow?  I would also need a CREATE. 

From the Actions I can tell, there is no way to dynamically create the UPDATE/CREATE query. 

What else can be done?


0 Kudos
1 Reply
Automation Master
Automation Master

Re: Is it possible to create a dynamic update/create query?

this is not possible with OOTB provided actions, you would need to use web service Lists.UpdateListItems Method (Lists) 

0 Kudos