flow don't recognize the Bucket id

(0) Share

Report

Posted on by EP-29071004-0

Hi,

i have a flow to create list of tasks based on an excel table, where each row is translated into a task.

in the excel table there is a column called "Bucket", which identify the Bucket name, where the task should be created.

when running the flow im getting an error that the bucket ID cant be identified, what am i missing?

thanks in advance

Categories:

General topics

All responses (3)

Answers (1)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Perez

This is because the Bucket ID identifier of the planner tasks, expects you to provide the ID of the bucket and not the name. To address this issue, you can add an action to list buckets from the plan ID and then iterate through those to use and point the bucket ID. Please see a reference screenshot below:

In your scenario, what you could do is, list rows from a table action and then list buckets action and then put an apply to each loop for the excel items and inside the loop add an action switch case and here switch case on the excel column that contains the planner names. In the case value put the planner name and then use the condition and referencing as i put in the screenshot.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Verified answer

v-bacao-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Perez ,

Please refer to the screenshot below to configure Flow.

Iterate through all the buckets and determine if the value name is equal to Bucket in the Excel table.

If they are equal, the value Id is configured in Bucket Id field.

Image reference:

Best Regards,
EP-29071004-0 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-bacao-msft thanks a lot it worked well