Answered

Putting Planner Description and Assignee into email with Flow

(1) Share

Report

Posted on by jster24

I'm using the "Send a digest email of all outstanding planner tasks" template in Flow, but need to be able to put the Tasks Description and Assignee into the email. Does anyone know how to pull these values into the Flow?

Categories:

General topics

All responses (15)

Answers (1)

Sort by

Verified answer

v-bacao-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @jster24,

I afraid that there is no way to put Assigned within planner task into the email in Microsoft Flow currently.
If you would like to get the value of Assigned in the planner task within Microsoft flow, you could vote for the similar ideal in the forum below:
https://powerusers.microsoft.com/t5/Flow-Ideas/Planner-Get-more-task-details/idi-p/72538
You could put the Tasks Description into the email by the following workaround:
Make some changes based on the original template. Initialize an array variable to store the information of the Task.
Use Get Task details action to get the Task description.
2.Use Compose action to store the information needed for each Task. Then append it to the array.
3.Then use the output of the array to create the Html table. Finally, send the table as the body as an email.
4.The configuration of Send email and Filter array actions is the same as the template.
It work, as below:
Take a try.

Best Regards,
Barry
GabrielStJohn Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, @jster24!

Thank you for posting on the Flow Community Forum! Have you had an opportunity to apply @v-bacao-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Is there a way to add Bucket Name (not bucket ID) and Assignee(s) to this email?
DanielaHo 241 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Barry,
Could you please describe in more detail the step 'Filter array' - perhaps a screenshot of this step expanded?
I love your solution just am having trouble repeating it myself 😉
Thanks in advance!
v-bacao-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @DanielaHo ,

In this Thread, Filter array is used to filter out unfinished tasks.

@not(equals(item()?['percentComplete'], int(100)))

Image reference:

Regards,
DanielaHo 241 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks - I got it to work
However my table is not as nicely formatted as the one in your screenshot.. I did specify within the 'send email' step "Is HTML? Yes"... the email does not show the table grid though so it is visually a bit confusing esp for tasks that have long descriptions. How did you format your table in the way you did?
DanielaHo 241 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks - I got it to work
However my table is not as nicely formatted as the one in your screenshot.. I did specify within the 'send email' step "Is HTML? Yes"... the email does not show the table grid though so it is visually a bit confusing esp for tasks that have long descriptions. How did you format your table in the way you did?
JMa 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for this solution @v-bacao-msft , however I get an error message in the "Compose" part of "Apply to each" i get an "Enter a valid json".
Any idea what I'm doing wrong?
v-bacao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JMa ,

Please refer to this image to configure Compose:

Best Regards,
JMa 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for quick reply @v-bacao-msft
I think i have typed in what in that box and double checked today but i still get the "JSON" error message.
Are there space bar blanks that would cause this error? I've typed mine without any spaces.
See below my screen shot.