Daily planner summary email Display User Assigned to Name for incomplete tasks

[HeyitsMe]

Hi all,

I'm trying to set up a flow that sends a daily email summary listing all planner tasks "in progress", but there isn't really an option for that (that I know of) so I'm trying to list all incomplete task. I successfully created a flow that sends the email listing all the data I wanted, except, I cannot get it to display the user assigned to by name instead of ID. I tried setting up an action to get the user (which does not fail), but the user name is not displayed anywhere in the email, and Display User Name is not a dynamic content option for the output array.

Any suggestions?

Thank you,

Tina

[yashag2255]

Hi @HeyitsMe 

As the get user action is in the loop, it will not fetch the data as dynamic content outside. One thing you can do is, initialize an array variable at the top and then in the loop, add an action to append to array variable and construct the json here: 

{

"Title": "select from outputs of planner",

"Date":"select from outputs of planner",

.

.

"Assigned to": "select from outputs of get user"

}

and then outside the loop, use this array to directly create the table. 

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!

[v-bacao-msft · Accepted solution]

Hi @HeyitsMe ,

Please try to refer to the following screenshot to configure the flow:

Spoiler

Feel free to let me know if you have any questions about this configuration.

Best Regards,

[CaoMJ]

I'm trying to follow this as well but ended up with this error message

Any idea what I did wrong?