Create HTML with Planner tasks including: Description, Due Date, Assigned To and Bucket Name

[MarvinE]

Hi everyone,

thanks to the help of this community I was able to create a flow that sends out a daily email with all overdue and outstanding tasks to a specific group. The E-Mail contains a table that show the Task Title, the Due Date and the Assigned User. 

What I want to do now is to also display the Bucket in which the task is in. Unfortunately my best approach shows all the buckets for every overdue and outstanding tasks, not just the actual bucket the tasks is in. (see picture below)

Do you see a way to include just the relevant bucket in the HTML table?

Please find the current flow below:

Thanks a lot! I appreciate your support!

All the best 
Marvin

[MarvinE]

Hi everyone,

any ideas on this? 

Do you think I can upgrade the current approach or should I follow a completely new approach?

Thanks a lot and all the best!

Marvin

[rimatos]

Hi @MarvinE ,

Where are you setting the contents of the "HTML Table" variable? I wanted to understand where you are inserting the bucket values. 

Additionally, where is it defined which is the current bucket for the task that you selected?

Regards,

Ricardo

[MarvinE]

Hey Rimatos,

after trying a few different approaches, I found a solution but listing the buckets and implementing a condition to see if the value id of the bucket matches the bucket id of the task. Although the flow takes 3x longer than before, the flow finally creates a HTML table with 4 columns stating the Task Title, Due Date, Assigned To, and the Bucket Name.

Thanks a lot for the support within the community!

All the best 

Marvin