Unanswered

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

All responses (4)

Answers (0)

Suggested answer

tils5zv 3 on at

Like (0)

Report

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

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":
MarvinE 21 on at

Like (0)

Report

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

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
rimatos on at

Like (0)

Report

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

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 21 on at

Like (0)

Report

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

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

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

Helpful resources

News and Announcements

Quick Links

Kickstarter Events…

Tuesday Tip #12 Start your Super User…

Tuesday Tip #13 Writing Effective Answers…

more Community News

Leaderboard

Featured topics

Product updates

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

Helpful resources

News and Announcements

Quick Links

Kickstarter Events…

Tuesday Tip #12 Start your Super User…

Tuesday Tip #13 Writing Effective Answers…

more Community News

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates