I am using a public template to send a daily email of planner tasks and need to update the date formats. I have looked this up but can't figure out the best way to configure it.
I have tried to wrap an expression around the start date but it keep saying expressions was invalid. Maybe I am writing it wrong but the expression used was:
I also tried to convert the time zone after setting the details but the flow failed:
Solved! Go to Solution.
I was actually trying to reformat the planner date that I already was receiving. I found another solution and used this to get around null values as well as reformat it:
hi @orolamba210 if you want to use the date into a planner task remember that you need to achive the correct format with Z at the end.
A correct format looks like this: 12/12/2020T00:00:00Z
you can try this
formatDateTime(items('Iterate_through_tasks')?['startDateTime'](),'yyyy-MM-ddTHH:mm:ssZ')
Proud to be a Flownaut!
I was actually trying to reformat the planner date that I already was receiving. I found another solution and used this to get around null values as well as reformat it:
User | Count |
---|---|
6 | |
6 | |
4 | |
4 | |
2 |
User | Count |
---|---|
8 | |
8 | |
4 | |
4 | |
4 |