cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jonboylib
Helper I
Helper I

Send an email when a Planner task is completed - email formatting

I am using the flow template 'Send an email when a Planner task is completed'

 

The only thing I have changes is the recipient email, apart from that the flow is default. I do receive the email but the formatting is ignored, also the 'Completed By' value is a random string of characters? See image below for flow and email.

 

Any ideas?

 

flowflowemailemail

1 ACCEPTED SOLUTION

Accepted Solutions
v-LilyW-msft
Community Support
Community Support

Hi @jonboylib 

You can user Get user profile (V2) action to get who completed the task.

If you want to format the date , you can use the formatDateTime function.

You can refer to the below screenshots to see if it helps.

vLilyWmsft_0-1638154001120.png

Copy 'body/completedBy/user/id' to User field from Send an email.

vLilyWmsft_2-1638154218713.png

Then delete 'body/completedBy/user/id' and select Display Name.

vLilyWmsft_4-1638154438022.png

Use formatDateTime function to format completed date.

Expression:

formatDateTime(triggerOutputs()?['body/completedDateTime'],'yyyy-MM-ddTHH:mm:ss')

vLilyWmsft_5-1638154493738.png

When a task is completed by Test2, I will receive an email like below.

vLilyWmsft_6-1638154795244.png

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

View solution in original post

1 REPLY 1
v-LilyW-msft
Community Support
Community Support

Hi @jonboylib 

You can user Get user profile (V2) action to get who completed the task.

If you want to format the date , you can use the formatDateTime function.

You can refer to the below screenshots to see if it helps.

vLilyWmsft_0-1638154001120.png

Copy 'body/completedBy/user/id' to User field from Send an email.

vLilyWmsft_2-1638154218713.png

Then delete 'body/completedBy/user/id' and select Display Name.

vLilyWmsft_4-1638154438022.png

Use formatDateTime function to format completed date.

Expression:

formatDateTime(triggerOutputs()?['body/completedDateTime'],'yyyy-MM-ddTHH:mm:ss')

vLilyWmsft_5-1638154493738.png

When a task is completed by Test2, I will receive an email like below.

vLilyWmsft_6-1638154795244.png

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

View solution in original post

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Users online (1,330)