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

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

MarvinE 21 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
rimatos Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
MarvinE 21 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

tils5zv 3 on at

Like (0)

Report
Copy link

Link copied!

I´ve just tried to do the same and ended with a simple approach that may work to you if you don´t have many Buckets.

I made an IF to re assign the name I want to the specific Bucket Id... Not so pretty, but works fine and keeps the flow efficient:

For example:

@{if(equals(item()?['bucketId'], 'xTxKJ1zqeE63tIT2Qjl5-GQAFpXV'), 'Revision', if(equals(item()?['bucketId'], 'dYKcM2V0A0WLB_oT8nnVhGQAPkgP'), 'In Progress', 'Pending'))}

(This will go on the right colum of the ""Select":

Was this reply helpful? Yes No