Skip to main content

I have a SharePoint List where the fields are:

Part Number

Price Level 1

Price Level 2

Price Level 3 

etc...

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 DPrice 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?

Thanks

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


Reply