Hello, this one sounds easy but it honestly frustrating me a bit.
How do you loop through a collection and just keep moving through the collection to evaluate the parts. In my collection I have TOOLNAME and RECOMMENDATION. Ultimately I would have around 5 recommendations per tool and those would be put into text variables and used in the output document generation.
Fields: ToolName (Text), Recommendation (Text)
Example Collection Content:
What Id like to end up with:
outlook_recommendation = "Drafting a message - http://wwww"
Principal issue: Moving through the collection and pulling out the individual parts of the collection for the current item in the loop so I can evaluate the current tool and add the recommendation to the appropriate variable.
I did something similar on Office 365 last week. Unfortunately, my contracted ended so I don't really have access to the tenant.
The only issue I ever found is that if there nulls in certain columns , it suspended the workflow but I seem to remember these were Data Time columns. Use plenty of Log Actions on any of the variables used to check their values.
Thanks, I have a question, when you use Query List it only allows Collection variables so are you saying to create a dictionary and place the collection from the Query List into it?
Unfortunately, I don't have any screen dumps but I do remember what my set up I have tested out.
Hope this helps.