Skip to main content

Hi there,
I am new to NAC and need a bit of help. I created a workflow that takes the data from one multi-text field called ‘Updates and Tracking Notes’ and moves it over to another field called ‘Total Updates and Tracking Notes” along with the name of the user(modified by) and the date and time of the entry(modified)

Anyway the workflow is working, however, it is not only updating the one record in the list but ALL records in the list.  How do I isolate so that only the record that the user updated is updated and not all of the records? am i somehow creating a loop? i just dont know where and how.

WF-
Run If Field ‘updates and tracking notes’ is not empty
Set workflow Variable
Build String


 

Hello @ChiGirl23 

 

Yes the update items action is a mass action, if you want to update all items with the save value this is a really effective way of doing do with a single action. 
 

what I think you are trying to achieve is to update each item differently, in that case you’ll need to first query the list to get the items back into a object setting the condition so it gets all items that it can that have not been updated, then add a loop for each action targeting that object collection. 
 

inside the loop for each use the current item id to set a condition on the update items action, currently you have no conditions so it will update all items, you need to add the condition id = loop for each > current item > id 

 

that way, the workflow will get the list of items that need updating, store them, loop through each and update each accordingly. 

 

Please let me know if you need any more advice. 
 

Jake 


Hi @ChiGirl23 

@Jake has answered this.

Just to reiterate - This is a common beginner mistake. You must specify the conditions which usually the current ID of the List Row - this variable is available to you.

Failure to specify the condition (leaving it empty) - means the update occurs to all the rows
Incorrect conditions - possibly no rows are updated

 

Hope that helps


thank you both, will work on specifying the condition today.  The workflow was migrated from Office365 Classic to NAC so I certainly need to make some tweaks and learn the new version...quick!


thank you both, will work on specifying the condition today.  The workflow was migrated from Office365 Classic to NAC so I certainly need to make some tweaks and learn the new version...quick!

We put in a place a manual process to get another team member to verify that all UPDATE action NEED to HAVE a CONDITION specified prior to release to Production

or you can add this verification step to a manual list


Excellent idea- I will reach out to the I.T. to let them know as well!


Reply