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

Modify the date format in a flow that sends an email of outstanding Planner tasks

I am working on a flow using the template "Send a digest email of all outstanding Planner tasks". It is working as expected, however the customer does not like the out of the box format of the date (2019-10-05T07:00:00Z). I have read all of the posts about the various ways to modify the date format, but I am having trouble doing it in the context of this flow.

 

I'm pretty sure I have to initiate a variable to convert the date for each instance of the "Due date". I have tried it using both the "convert time zone" method (pictured below) and an expression that formats the date, both using a variable within an "apply to each" box. In each case, after setting the variable, the table that is returned in the email has the same Due Date for all the records. It seems to be setting it once and then using it for all the records (see copy of email below). I've tried playing with the concurrency settings but that didn't seem to change anything.

 

Below is a picture of the entire flow. 

planner_flow1.PNG

planner_flow_email.png

2 REPLIES 2
RobElliott
Super User
Super User

Hi @agoneau, you definitely need to remove the Set variable as it isn't necessary and it is causing the same date to be added to each item in the html table. I'll think about what the solution is to convert each date to the format you want for the table.
Rob
Los Gallardos
If I've answered your question or solved your problem. , please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks..

Thank you for your response. I tried both methods of reformatting the date outside of a variable and neither has any effect. I'm stumped. Let me know if you think of anything.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,341)