
Announcements
I used the Flow Template from here: Create a daily summary of Planner Tasks by Bucket | Microsoft Power Automate
I have managed to remove and filter out the Completed Tasks. Now it creates a great Email summary by Bucket. I cannot figure out how to Sort the Buckets. I want to Sort by Title and I cannot figure it out.
Issue number two, I am trying to Take Start Date and Format it and cannot do it.
When I go to the flow where it exists, you get in Planner Value of Start Date... if I try to use FormatDateTime('Field'),yyyy-MM-dd then I dont get value of Start Date, I only get "Current Item"
Here is what it looks like in the Set Variable:
If I try to use the FormatDateTime() I cant even see the Planner Fields:
Issue 1: have you tried this, it works for me;
https://www.tachytelic.net/2021/04/power-automate-sort-array-objects/
Issue 2: I do the next, maybe this works for you too;
if(empty(item()?.startDateTime),'-', formatDateTime(item()?.startDateTime, 'MMM d'))
Let me know if this Solved the issue. Thank you.