I'm busy playing with the Planner connector and running into nested loop issues.
Ultimately I want to get my data into PowerBI, so I'm just using Excel as a stop-gap to collect the data (using insert rows) before I pull it into PowerBI.
I get a list of Plans and can write this easily enough to excel.
For each Plan, I get a list of buckets - but here it breaks down. I can write the buckets of a specific plan if I input the ID, but if I want to iterate through a list of Plan ID's, I'm stuck.
I still need to get a list of tasks per bucket, and a list of task details per task, but I can't go any further than Plans because I can't nest loops. I don't mind creating a fixed flow for each plan, but creating fixed flows for each bucket of each plan is a little tedious.
So - I know I can't nest loops, but I'm not sure how else to do this. If I try and loop through a collection outside of the initial "Apply to Each" I get this error;
The output you selected is inside a collection and needs to be looped over to be accessed. This action cannot be inside a foreach.
Okay - so how do I loop over a collection and apply actions to each item?
I'd also like to avoid inserting duplicates into my excel every time I run the flow - but this also seems to require some level of nested loops - taking a list of the source and iterating through it to see if each row exists in a destination list....which also needs to be iterated through to test for each source line...
Any advice or direction would be greatly appreciated!
Kind regards,
Russel
