Answered

Get items Order By using Day from Date

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi community,

Is there a way to Order/Sort the Get Items from a SP list based on the Day in a date?

I'm creating a HTML table of Birthdays for the Month and sending via email. This works fine but I was wondering if it's possible to sort the birthdays by Day before creating the table? My basic process is:

Get Items --> Filter Array (Get Items) to current Month only on Birthday field --> Create HTML Table (Filter Array)

I've tried a few things with my latest (failed) iteration of my Order By code being:

int(split(formatDateTime(Item().Date_x0020_of_x0020_Birth,'MM-dd'),'-')?[1]) asc

Error: " Unable to process template language expressions in action 'Get_items' ... cannot be evaluated because property 'Date_x0020_of_x0020_Birth' cannot be selected."

Any help would be great!

Thanks

PS I was able to use Date_x0020_of_x0020_Birth asc but this sorts oldest person to youngest person, which isn't what I want.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-litu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous,

The order By only support the "columnName asc" or "columnName desc", not support add expression into the order by.

URI Conventions (OData Version 2.0) · OData - the Best Way to REST

For example:

As a workaround, you could create a calculate column in the SharePoint list, and set its shows as MM formate of "Date of Birth"

MONTH function - SharePoint (microsoft.com)

Then use the calculate column to approach the Order By:

"CaculateColumn asc"

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@v-litu-msft

Thanks Lin,

I thought that may have been the case. I’ll consider the calculated column.

Cheers

Was this reply helpful? Yes No