Getting bucket Name

[frederikbisback]

I have a planner bucket list and based on a create task in a plan, I receive a bucket ID where it has been created.

How can I get the Bucket Name based on the two items

* Buckets List Shown as here below:

[
  {
    "@odata.etag": "W/\"JzEtQnVja2V0QEBAQEBAQEBAQEBAQEBASCc=\"",
    "name": "BUCK03",
    "planId": "w_4V8-0QJE6Wl_TWKvRmipYAB2MC",
    "orderHint": "8586618331113434567P6",
    "id": "IRJ08qbj7kOw2tDzThTVgJYAG-Tf"
  },
  {
    "@odata.etag": "W/\"JzEtQnVja2V0QEBAQEBAQEBAQEBAQEBASCc=\"",
    "name": "BUCK02",
    "planId": "w_4V8-0QJE6Wl_TWKvRmipYAB2MC",
    "orderHint": "I#",
    "id": "x_yNrLZbLEm4v0kniek0X5YAI0qi"
  },
  {
    "@odata.etag": "W/\"JzEtQnVja2V0QEBAQEBAQEBAQEBAQEBASCc=\"",
    "name": "BUCK01",
    "planId": "w_4V8-0QJE6Wl_TWKvRmipYAB2MC",
    "orderHint": "[v",
    "id": "_WBroQk8R0ah-yiAl1fJfZYAPvUV"
  }
]

* Based on the create task I get a Value Bucket Id that containce one of those three.

How I can match the bucket list to get the name of the bucket?

Thanks

[v-bacao-msft · Accepted solution]

Hi @frederikbisback,

Do you want to get the name of the bucket to which the task you just created belongs?

You could use Get a task to get the id of the Bucket to which the task belongs.

Use List buckets to get the value of all buckets, including id, name.

Use Condition to determine whether the id value obtained by the Buck id and list buckets obtained by Get a task is equal, get the expected bucket id, and then output the corresponding bucket name.

You could also use variables to save this name.

Image reference:

Best Regards,

Barry

[frederikbisback]

Thanks, I was just stuck at the last option. It can continue. Thanks.

[TrevorS]

@v-bacao-msft This solution has normally worked great but sometimes I get an item output without the Bucket Name populated. Have you ever ran into this? 

[dushyantb]

@v-bacao-msft  You also get Bucket Id directly from the trigger itself.

Maybe it wasn't there when you posted the answer, but with that, you don't have to "Get Task".

[TrevorS]

@dushyantb the Bucket ID is the generated ID and not the Bucket Display name. What's worse is Flow doesn't handle variables and parallelism well so you'll have to wait for the "for each" loop or risk mixed up data in your output.

[dushyantb]

@TrevorS you missed my point. I know Bucket ID is not its name, but a unique identifier.

My point is, you dont need to use "Get a Task" to get the Bucket ID. It is included from the trigger itself, so you can use that to compare inside the condition step.

[FH1000]

i might be missing something, when i try this it gives me the name of the wrong bucket... any idea why?

I want to use the output from the condition in an email, but when i select value name for bucket list it will cycle through and use the last one in the email, how can i get only the bucket name from the condition published in the email?

sorted

[andrewraia]

Is there a more efficient way to do this so you don't have to loop through the entire list every time? Maybe creating an array that joins the data together first?

[maciejwitos]

Hi.

You can also use the Data Operation activities to get the Bucket Name for Each Task.

The expression at the end is:

first(body('Filter_array_with_Buckets'))?['Name']

BR

[kRebus]

Hi Macie,

Where do you get this "Print Name" operation? I just see compose.

[maciejwitos]

Hello,

This is a Compose activity. I just changed it name. 🙂

[mehyc]

Hello, this might be late but when I was doing this and was testing out the result but I always have the result of "false" in the condition. I did a comparison with the "Get Task" and "List Buckets". For Get task the value is stored in Bucket Id and in List Buckets it is stored in Id which when you check it they have the same data. I do not know where the error is. 

[ARC_afabozzi]

Old post but figured I would chime in and say there is an easier way.

Here is a walkthrough I made with pics.

Add an action below the trigger called Send an HTTP request (Office365 Groups type)

• URI – https://graph.microsoft.com/v1.0/planner/buckets/{bucket-id}
• Method – GET
• Body – I left it blank
• Content-Type – application/json

Click test in the upper right corner to get the JSON output then copy it.

Create another action called Parse JSON 

• Content – The Body dynamic content of Send an HTTP request
  • @{body(‘Send_an_HTTP_request’)}
• Schema – Click Generate from sample and paste what you copied earlier and click done

After that you can now select name as a dynamic content option from the output of Parse JSON

Reference:

https://learn.microsoft.com/en-us/graph/api/plannerbucket-get?view=graph-rest-1.0&tabs=http

[Romeri6]

hey there im just trying to do something simillar but im not able to make it....

 I just want  to copy all the tasks from a plan in planner to a sharepoint list... I have already used list tasks then create an item in sherepoint so it works...  but the thing is that bucket name doesn´t appear ... i guess is because i didnt select bucket list... when I select both... (bucket and task list)  something happens with apply to each.... so it does an error ... is there any way that you can copy a planner task including the bucket names in a sharepoint list?

Thanks a millon