Crow Canyon Software Forum
Process all items in a list
Quote from pf-amalin on August 31, 2022, 2:57 pmWe have a list with a required column, but several thousand items that were imported from another system don't have anything in that required column. I have a workflow that uses a Query List action based on a view to add "unknown" to the blank items, but the item limit of 100 means it will have to be executed many times. I was thinking of scheduling the WF to run every few minutes until all are processed, but that seems pretty inefficient. Is there a better way to process ALL items in a list?
We have a list with a required column, but several thousand items that were imported from another system don't have anything in that required column. I have a workflow that uses a Query List action based on a view to add "unknown" to the blank items, but the item limit of 100 means it will have to be executed many times. I was thinking of scheduling the WF to run every few minutes until all are processed, but that seems pretty inefficient. Is there a better way to process ALL items in a list?
Quote from supportTeam on August 31, 2022, 3:44 pmIf you have these items imported to the system in a csv file locally and unique identifier column exist for these list items, we can setup a parse csv action with update item mode that will update existing items that has blank value in the column. Please refer app manual from https://www.crowcanyon.help/article/670/
If you have these items imported to the system in a csv file locally and unique identifier column exist for these list items, we can setup a parse csv action with update item mode that will update existing items that has blank value in the column. Please refer app manual from https://www.crowcanyon.help/article/670/