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.
Collection: colRecommendations
Fields: ToolName (Text), Recommendation (Text)
Example Collection Content:
What Id like to end up with:
skype_recommendation = "How to make a call - http://zzzzz <br/> Setting up your headset - http://xxxxx"
outlook_recommendation = "Drafting a message - http://wwww"
Assumptions:
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.
Hi
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.
Good luck
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?
Yes, definitely. I may have a screen dump somewhere of it in use. Will check in the morning (BST).
Daniel
Get Outlook for Android<https://aka.ms/ghei36>
Hi Mark,
Unfortunately, I don't have any screen dumps but I do remember what my set up I have tested out.
Hope this helps.