Flow to add planner bucket/tasks to an excel sheet

Question

Hi all,&nbsp;I've created a&nbsp; Flow to add Planner bucket/tasks to an excel (Document Library) table.&nbsp;When I run the flow it populates the table but adds all the tasks to all the buckets.&nbsp;Where am i going wrong...&nbsp;Any advice would be greatly appreciated.&nbsp;&nbsp;

ssh_sony · Answer

Thanks&nbsp;Damien_Rosario&nbsp;&nbsp;I resolved the issue by moving the "Add row into a table" action to within the Iterate assigned user profile section....&nbsp;I used the bucketID to identify the tasks with the bucket.....&nbsp;

damien_rosario · Answer

Hi&nbsp;ssh_Sony&nbsp;&nbsp;We may need more info from you. I can't make heads or tails of the screen shot I'm seeing as standalone.&nbsp;How have you programmed Power Automate to know which tasks to focus on to add to your Excel table? From what I can see, it's accessing all tasks and not a specific ID of one.&nbsp;If you can please show the flow above and below of the screen, it'll give us a good idea of the bigger picture of what you have programmed and where things may have fallen over.&nbsp;&nbsp;I don't believe the current screen is enough to tell us that story as yet.&nbsp;CheersDamien

damien_rosario · Answer

Hi&nbsp;ssh_Sony&nbsp;&nbsp;Well done pal!&nbsp;&nbsp;Wishing you all the best with your automation!&nbsp;CheersDamien

Forum Discussion

Flow to add planner bucket/tasks to an excel sheet

Share

Resources