cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gwill1983
Helper III
Helper III

Get Calendar View Of Events (V3) Order By Start Time

Hi all,

 

I am creating a flow to send me a summary of my outlook calendar on a weekly basis. It is all working fine, but I would really like to be able to sort the data so that it is chronological order within the HTML table.

 

My flow is as below:

 

Gwill1983_0-1643374139296.png

 

This then produces an email that looks like the below:

Gwill1983_1-1643374255954.png

 

I cannot get the 'order by' function to work in order to sort this table into a list that shows the earliest meeting at the top working down to the last meeting at the bottom

 

Can anybody point me in the right direction?


Thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Dual Super User
Dual Super User

Hi @Gwill1983,

 

Try to add Start/DateTime asc in your Sort by field.

 

Below is an example:

Start/DateTime asc

 

startdatetime_filterquery.png

 

View solution in original post

2 REPLIES 2
Expiscornovus
Dual Super User
Dual Super User

Hi @Gwill1983,

 

Try to add Start/DateTime asc in your Sort by field.

 

Below is an example:

Start/DateTime asc

 

startdatetime_filterquery.png

 

Thanks so much. It works perfectly! 

 

 

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

Users online (3,504)