cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

How to populate multiple Bucket Ids from SharePoint list when create a planner task?

Greetings,

 

I am creating a new Planner task for each new SharePoint item and post to Teams. Basically need to be able to populate the Bucket Id from a field labeled "Stage" from my list in Sharepoint. But I received the error message below:

Capture.PNG
 
My flow's diagram:
Capture.PNG
 
Ultimately, my goal is to create tasks in SharePoint with Stages and Planner can assign the tasks by Stages(bucket).
 
Can anyone help me with the error? I'm new to Flow...Thank you.
 
5 REPLIES 5
Super User II
Super User II

@New2Flow 

Hi there. So, first, I'd like to make sure you are getting that error on the step "Create a Task", or is it showing someplace else?

 

Next, we want to make certain that the Stage field in your SP list contains the actual ID of the buckets you want to use.  Those aren't inherently connected.

 

Seeing the rest of the error might help, at least the line with "Message".

 

Either way, 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.

Community Support
Community Support

 

Hi @New2Flow ,

 

It should be noted that this field needs to be filled with id instead of Bucket Name.

 

You could use Compose to output Stage Value on Create a task action to see if its actual value meets the requirements.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @edgonzales ,

 

Yes, I got the error on the step "Create a Task". Do you have any suggestions on how to fix it?

 

Thank you.

Hi @v-bacao-msft ,

 

Can you be more specific on the solution? I got the Bucket ids (i.e., 3 bucket ids in my case), but how can I fill the field? Thank you.

@New2Flow 

The point we are asking on the Bucket ID's is to make certain we're using the same process to troubleshoot.  When we look at the buckets through the front end of Planner, we see what is called the "name".  In my pic below, you can see that I have a bucket named "Demo", but the ID is a little further down (the long string that starts with 7ew...).  That is the unique identifier that the step wants when defining the specific bucket.

 

20200116a.PNG

 

If that doesn't correlate to your "Stage Value" in your SP list, then things will bomb out.

 

If your buckets are pretty static, then you can make a quick flow to list the buckets in the plan and then build a list connecting the bucket name to the ID's, OR just add the relevant ID's to your SP list somewhere.

 

Keep at it, this is a good process and will work great once we get past this bit.

-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.

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (19,360)