I've got a workflow which uses a query action to create a collection. but sometimes I would like to run a alternative set of values through the workflow in the same collection.
If I use the add item to collection action it adds quotation marks, which I can't easily remove with a regex action. I choose text and add 69384,68825,68808 the output is: :"69384,68825,68808"]
Can someone tell me how to manually add a set of items to a collection with the least amount of work?
Hi @EricV
Just use a List to store your values. Then Query that List
Step 1. Create your List. Very straightforward.
Decide the type of values which you want in your list.
Below is a list of Fruits.
Step 2: In your workflow. add a Query List action. configure as follows
List: Your list name
Filter: Set your filtering. I take all 12 fruit items
Sort: Set your sorting. I use filter by Title
Output Type: Select separate output per column (needed to create a collection)
Select the column "Title" and provide a Collection variable to store the output
Output:
Use a Log to History to display the collection
["Apple","Banana","Cherry","Grape","Lemon","Lime","Mango","Orange","Papaya","Peach","Pear","Strawberry"]
Hi Garret, thank you. Not really the solution I hoped for, cause this takes quite some time to setup for each custom run. The original solution also works like this. I hoped for an option to insert the values directly in a workflow action like "set variable".
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.