Query List - option to automatically create variables and map all columns to these variables
Have an option to automatically create variables and map all fields to these variables so I can use them in the Workflow without having to create them one-by-one manually.
You can imagine what I have to do when there are 150 columns. I have to create 150 variables in the workflow, select 150 columns/fields, and then map all 150 fields to variables manually !!
Hi Kevin. Sorry I'll be a bit more specific. If you create a Site Workflow, and in this Site Workflow add a Query List action, which allows you to select a Sharepoint List capturing multiple items for this list being selected.
If you then open up the Query List action and configure it, you'll need to select all the Fields (or columns) one at a time, and then select a custom variable to map to each Field.
So now I have 150 columns. What I have to do is select 150 columns one at a time, create 150 custom variables, map each one of these variables.
I've done this a few times already because I have for example a Site Workflow that queries the Sharepoint List I'm interested, and I have to output these results into a CSV file by way of scheduling the workflow to run daily/weekly.
Kevin Annfield commented
Maybe I'm not understanding what you want to do, but why do you have to create a variable for each column in your list? All list columns are available in the workflow actions under the "Item Properties" tab in the "Insert Reference" window. You certainly don't need to have a one to one mapping of a column to a variable.