cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
dipetersen
Nintex Newbie

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 

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

Thanks

Labels: (2)
Tags (2)
0 Kudos
Reply
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
Reply