web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Sort HTML Table in Ema...
Power Automate
Unanswered

Sort HTML Table in Email Summary Planner Flow

(0) ShareShare
ReportReport
Posted on by 58

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.

 

Xnip2021-03-07_16-04-55.png

 

 

Issue number two, I am trying to Take Start Date and Format it and cannot do it. 

Xnip2021-03-07_16-17-12.png

  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:

 

Xnip2021-03-07_16-24-55.png

 

If I try to use the FormatDateTime() I cant even see the Planner Fields:

 

Xnip2021-03-07_16-25-46.png

 

 

Categories:
I have the same question (0)
  • Community Power Platform Member Profile Picture
    on at

    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'))

     

    2021-09-01_22-52-18.png

     

    Let me know if this Solved the issue. Thank you.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard