AnsweredAssumed Answered

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

Question asked by dipetersen on Mar 15, 2017
Latest reply on Mar 15, 2017 by emha

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?