cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HeyitsMe
New Member

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

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

HeyitsMe_0-1594999809534.png

HeyitsMe_1-1594999876164.pngHeyitsMe_2-1594999948156.png

 

HeyitsMe_3-1595000013853.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-bacao-msft
Community Support
Community Support

 

Hi @HeyitsMe ,

 

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

Spoiler
5.PNG6.PNG7.PNG8.PNG

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

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
yashag2255
Dual Super User II
Dual Super User II

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
Community Support
Community Support

 

Hi @HeyitsMe ,

 

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

Spoiler
5.PNG6.PNG7.PNG8.PNG

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

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

CaoMJ
Frequent Visitor

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

CaoMJ_0-1610346412618.png

CaoMJ_1-1610346427258.png

 

Any idea what I did wrong?

 

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Automate User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (36,724)