Adding List Buckets to my Flow to get Bucket Name

[rixmcx59]

Hello all, I need to include Bucket Name and not sure where to insert "List Buckets" action. any help would be much appreciated. The flow works great, adds tasks and task details to a SharePoint list but I get the Bucket ID instead of the name.

[edgonzales]

@rixmcx59 

Interesting that there isn't an easier way to do this, but since you have the bucket ID, you can use the List Buckets step and then filter by that ID to get the name of the bucket.

Keep us posted.

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

[rixmcx59]

Yes, exactly, I have to filter on Bucket ID, my question is where to insert the action and what type, condition or array. I believe I need to use a filter array but I don't know where to insert it.

Thanks

[edgonzales]

Ah, got it.  So, where are you getting the bucket ID?  You could put the List Buckets right after that, and then the filter array immediately after that.  

Keep in mind that the output of the "Filter Array" will still be an array/list even if there is only one thing on it.  So you'll want to do something to avoid another Apply to Each loop.  Check out Elaiza's video on that:  

https://www.youtube.com/watch?v=whXSlYV3Ffg

Keep us posted.

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

[rixmcx59]

List tasks has Bucket ID but no name, so I add a For each, then add List Buckets, then Add a filter array, then how do I use the output of the array in my create item, I am creating all tasks in SharePoint not one item, 396 records.

[edgonzales · Accepted solution]

Ok, so I would put List Buckets just after your List Tasks (so outside of the Apply to Each loop).

Then, inside the apply to each loop, maybe right after the Get Task Details, add a Filter Array step:

The comment about one item being on the list is the results of Bucket details from your filter array.  There will be only one record with that bucket ID in that list, but it will still be in an array.  So use that compose step at the end to trick Power Automate into only giving you one "name".  The output from your compose is what you would use in your Create Item step for the Bucket Name.  Otherwise, it will trigger another Apply to Each loop, which is less-than-ideal.

Good luck!

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

[rixmcx59]

Thank you very much, you made my day.