Forum Discussion

ssh_Sony's avatar
ssh_Sony
Copper Contributor
Feb 05, 2020

Flow to add planner bucket/tasks to an excel sheet

Hi all,   I've created a  Flow to add Planner bucket/tasks to an excel (Document Library) table.   When I run the flow it populates the table but adds all the tasks to all the buckets.   Where ...
Excel
Microsoft Flow
PowerApps
Damien_Rosario's avatar
Damien_Rosario
Silver Contributor
Feb 07, 2020

Hi ssh_Sony 

 

We may need more info from you. I can't make heads or tails of the screen shot I'm seeing as standalone.

 

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.

 

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. 

 

I don't believe the current screen is enough to tell us that story as yet.

 

Cheers

Damien

  • ssh_Sony's avatar
    ssh_Sony
    Copper Contributor
    Feb 07, 2020

    Thanks Damien_Rosario 

     

    I resolved the issue by moving the "Add row into a table" action to within the Iterate assigned user profile section....

     

    I used the bucketID to identify the tasks with the bucket.....

     

    • Damien_Rosario's avatar
      Damien_Rosario
      Silver Contributor
      Feb 09, 2020

      Hi ssh_Sony 

       

      Well done pal! 

       

      Wishing you all the best with your automation!

       

      Cheers

      Damien

Resources