Flow to add planner bucket/tasks to an excel sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1152437%22%20slang%3D%22en-US%22%3EFlow%20to%20add%20planner%20bucket%2Ftasks%20to%20an%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1152437%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20created%20a%26nbsp%3B%20Flow%20to%20add%20Planner%20bucket%2Ftasks%20to%20an%20excel%20(Document%20Library)%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20run%20the%20flow%20it%20populates%20the%20table%20but%20adds%20all%20the%20tasks%20to%20all%20the%20buckets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhere%20am%20i%20going%20wrong...%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ssh_Sony_0-1580907515588.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F169120i1AB73391E69B76D6%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22ssh_Sony_0-1580907515588.png%22%20alt%3D%22ssh_Sony_0-1580907515588.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20advice%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1152437%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1157530%22%20slang%3D%22en-US%22%3ERe%3A%20Flow%20to%20add%20planner%20bucket%2Ftasks%20to%20an%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1157530%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F376494%22%20target%3D%22_blank%22%3E%40ssh_Sony%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20may%20need%20more%20info%20from%20you.%20I%20can't%20make%20heads%20or%20tails%20of%20the%20screen%20shot%20I'm%20seeing%20as%20standalone.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20have%20you%20programmed%20Power%20Automate%20to%20know%20which%20tasks%20to%20focus%20on%20to%20add%20to%20your%20Excel%20table%3F%20From%20what%20I%20can%20see%2C%20it's%20accessing%20all%20tasks%20and%20not%20a%20specific%20ID%20of%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20can%20please%20show%20the%20flow%20above%20and%20below%20of%20the%20screen%2C%20it'll%20give%20us%20a%20good%20idea%20of%20the%20bigger%20picture%20of%20what%20you%20have%20programmed%20and%20where%20things%20may%20have%20fallen%20over.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20believe%20the%20current%20screen%20is%20enough%20to%20tell%20us%20that%20story%20as%20yet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1158174%22%20slang%3D%22en-US%22%3ERe%3A%20Flow%20to%20add%20planner%20bucket%2Ftasks%20to%20an%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1158174%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20resolved%20the%20issue%20by%20moving%20the%20%22Add%20row%20into%20a%20table%22%20action%20to%20within%20the%20Iterate%20assigned%20user%20profile%20section....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ssh_Sony_0-1581076116791.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F169609i1BDAFA6B2A39CE84%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22ssh_Sony_0-1581076116791.png%22%20alt%3D%22ssh_Sony_0-1581076116791.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20used%20the%20bucketID%20to%20identify%20the%20tasks%20with%20the%20bucket.....%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ssh_Sony_1-1581076463597.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F169611i03B160F8C59533B9%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22ssh_Sony_1-1581076463597.png%22%20alt%3D%22ssh_Sony_1-1581076463597.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1163196%22%20slang%3D%22en-US%22%3ERe%3A%20Flow%20to%20add%20planner%20bucket%2Ftasks%20to%20an%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1163196%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F376494%22%20target%3D%22_blank%22%3E%40ssh_Sony%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWell%20done%20pal!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWishing%20you%20all%20the%20best%20with%20your%20automation!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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 am i going wrong...

ssh_Sony_0-1580907515588.png

 

Any advice would be greatly appreciated.

 

 

3 Replies

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

Thanks @Damien Rosario 

 

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

 

ssh_Sony_0-1581076116791.png

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

ssh_Sony_1-1581076463597.png

 

Hi @ssh_Sony 

 

Well done pal! 

 

Wishing you all the best with your automation!

 

Cheers

Damien