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