Power Platform Community Forum Thread Details

Hiya,

I'm trying to setup a flow/power automate getting a table from a sharepoint site and creating a task out of the lines of the table.

This all works quite OK as I am able to select the the lines and create the task.

I'm now just finetuning a little and would like to to use the name from the owner that I get from the table as the bucket for the task so that I have number of buckets for different persons and have their tasks listed there.

Because it could be that the table gives the name of someone not in the team, I already cross check if the owner in the table is part of the teams page with a quick comparison between the names while looping though the team members

So technically I have 2 options to select the correct name, either from the teams list, or the sharepoint list.

But when I try to add the name as a bucket this always seems to fail.

I tried adding the bucket manually to the planner, or removing it, but that doesn't make a change

For some reason every value that I want to put in the bucket field is not recognized by the flow as a valid input.

Not even when I create a variable to take the "display name", and ever more so not even when I just copy paste the exact name from the bucket I've made. Only with the pull down menu and the predefined buckets I'm able to select the category.

But obviously then I cannot divide the tasks with the flow.

Hope it's a little clear what I'm aiming to do.

Should this be possible, and if so, what would I need to change to make this work?

Alternative for me would be to add the owner to the owner section of the task. But this has a similar failure...

Thank for any input 🙂

Categories:

Building flows

Hello @kiki_musampa ,

the 'Create a task' action requires 'Bucket Id' as an input, not bucket name. If you select any bucket from the dropdown menu, click on the 3 dots and 'Peek code', you'll see that the parameter is not the 'name' of the bucket, but the 'id'. It shows the available bucket names in the dropdown only to simplify the selection.

That means you should get the bucket Id before you create a task:

'List buckets': to list all available buckets in the plan
'Filter array': from all the available buckets filter only the bucket where 'Name is equal to DisplayName'
User the 'Id' output from the 'Filter array' in the 'Create a task' action. The output should contain only the single bucket so don't worry about the 'Apply to each'.